AD 79-01-01
Registered aircraft · 8,424
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:79-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-01-01')
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:79-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-01-01') 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.
N1028WArt Air Partners LLC · Louisburg, NCN102CCPj Squared LLC · San Antonio, TXN102FAMedic Choppers LLC · Springdale, ARN102HLKopp Michael · Reno, NVN102JMHeld John S · Cincinnati, OHN102QAir N Travel LLC · Cannelburg, INN102SBfb Enterprises LLC · Larned, KSN1030WChalupa Air LLC · Dover, DEN1031WBilco Air LLC · Danville, ILN1032WOhlinger Mark A · Copley, OHN1033WPunci Aviation II LLC · Port Washington, WIN1036TSlaughter Terry D · Perryton, TXN1039TJera · Johnson City, TNN103BABemidji Aviation Services Inc · Bemidji, MNN103EYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN103LHKavalair LLC Series D · Marion, MTN103SEClear Prop Aviation LLC · Sioux City, IAN103SMHermack John F · Toms River, NJN103WWWilkin Richard G · Monticello, ILN1040TTen Forty Tango LLC · Wichita, KSN1040WFoolish Pleasure Aviation Inc · Lewes, DEN1042RSale Reported · Los Angeles, CASale reportedN1042TJbr Leasing Inc · Orlando, FLN1043WLatitude Aviation LLC · Cedar Rapids, IAN1044WAngier 66 LLC · Durham, NCN1045WButler Richard S · Poplar Grove, ILN1047W1047w LLC · Oakland, TNN104FMEide Machinery Sales Inc · Minneapolis, MNN104LARegistered aircraftN104MMBaron 104mm LLC · Rohnert Park, CAN104WWJarosak Peter J · Valparaiso, INN1050TThrash Scott · Hesston, KSN1054WHeavers George S · Oakland, CAN1057WMaisano Abby · Hendersonville, TNN1058RWindle Air Baron LLC · Lynchburg, VAN105FADebbie Air LLC · Perkasie, PAN105RKEwing John M · Cumming, GAN1060RCooper Don F · Great Falls, VAN1060WHarvey Ara Jr · Hernando, MSN1061DCcr Aviation LLC · Summit, NJN1061FFoxtrot Flight LLC · Clarksdale, MSN1061WHollinshed Thomas O · Fayetteville, NCN1062WSale Reported · Douglas, GASale reportedN1063WDakota Land LLC · Simms, MTN1064CBayside Development LLC · Bellingham, WAN1065BRegistered aircraftN1066HBaronhfl LLC · Jacksonville, FLN1066PG&K Management Co LLC · Ocala, FLN1069WElk Lake Group Inc · Plymouth, MNN106BABemidji Aviation Services Inc · Bemidji, MN
Back to AD 79-01-01