AD 72-01-07
Registered aircraft · 1,150
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-01-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-01-07')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-01-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-01-07') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1887AErickson Paul F · Wasilla, AKN1888AAlaska Tailwheel LLC · Fairbanks, AKN1890AJohnson Air LLC · Anselmo, NEN1891AEntriken Birch N · Reno, NVFirst renewal noticeN1892ALesmeister Dean J · Kindred, NDN1896AHudson Jared M · Anchorage, AKN189TNew London Taildraggers · Lynchburg, VAN18GEHorvitz Martha E · Poway, CAN18JZAcv Group LLC · Mckinleyville, CAN18LJKallam Jerry C · Palmer, AKFirst renewal noticeN18SNSmiley Stephen P · Canandaigua, NYN18YHBaker Property Management · Indian Valley, IDN18ZFReel Chad A · Wasilla, AKN18ZZGardom Brandon D · Spirit Lake, IDN1906AHoyer Larry B · Fort Peck, MTN1911ADay Patrick J · Bloomer, WIN1912AWebber David A · Delta Junction, AKN1914AElmore James C Jr · Hedgesville, WVN1919AHolman Terence A · Portland, ORN1927AHigh Wind Aviation Services LLC · Ludlow, VTN1930ABoyer Jason Allen · Kasilof, AKN1934ASlayden Steven M · Rhome, TXN1939ACasabonne Family Ltd Partnership · Hope, NMN193TBurmeister Aaron · Nenana, AKN194TNicholson Earl J · New Milton, WVN1950PJefferies R Wayne · Durango, COFirst renewal noticeN1950YCostanza Joseph Vincent · Marlton, NJN1952PWinterton Gary S · Lindon, UTN1953MFugate Terry L · Atoka, OKN1953VAarestad Potato Co Ltd · Hillsboro, NDN1957ASkywagon Aero LLC · Wilmington, DEN1959AWhite B Scott · Castlewood, VAFirst renewal noticeN195THandyside Bryan P · Duluth, MNN1968PWygant Michelle R · Copper Center, AKN1983PCarlson Andrew J · Ashville, NYN1984ASuper D Group LLC · Hanoverton, OHN1988ABroussard Lewis A Jr · Morse, LAN1991AHolman Daily A · Canby, ORN1994AHuppert Gerald P · Palmer, AKN2014PAerial Sign North · Lakewood, NJN202TMurray James A · Wasilla, AKN203TProfota Don L · Bozeman, MTN204TTFalkenberg Randy J · Edmonson, TXN205TClark Stephen N · Walnut Cove, NCN206TSchou Brice N · Thomas, OKN20821Danielson Robert DBA Conventional Air · Decatur, MIN2102VGiovanini Terry L · Bozeman, MTN2113ASale Reported · Glasgow, MTSale reportedN2115AJj Ventures LLC · Billings, MTN2124NLivestock Service Inc · Douglas, AZ
Back to AD 72-01-07