AD 85-01-01
Registered aircraft · 317
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:85-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:85-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:85-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:85-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.
N223LHLelah Holdings Limited Partnership · Reno, NVN227DCEllen Vineyards Inc · Sanger, CAN22BBSpillman Robert · Port Orange, FLN23605Een Aviation LLC · Arlington, TXN246CKMccarty David M · Baker City, ORN249CPAngels Envy Aviation LLC · Denison, TXN24SPUzochi Inc DBA · Albuquerque, NMN267COldham Matthew Stephen · Lewisville, TXFirst renewal noticeN268CACaruthers LLC · Moundville, ALN26RERrr Aviation LLC · Gulfport, MSN270MNardi Greg P · Missoula, MTN278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN284PMArtic Legacy Aviation LLC · Anchorage, AKN28KPState Of Montana · Helena, MTN290CCMonument Aviation LLC · North Chesterfield, VAN290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYN291CCMobile Ehr Inc · Argyle, TXN292APlacebo Air LLC · Ridgecrest, CAN294TTUncommon Solutions LLC · Hollis, NHN299VMSs Leasing LLC · Tulare, CAN2UVDependable Freight LLC · Bethel, AKN300VAAeon62 Holdings LLC · Plano, TXN305TTZulu Air LLC · Opa Locka, FLN308RMN308rm LLC · Boca Raton, FLN312VFCentral Virginia Aviation Inc · North Dinwiddie, VAN321DZNardi Greg · Missoula, MTN322RN322r LLC · St Simons Island, GAN325RRCentral Virginia Aviation Inc · North Dinwiddie, VAN32BAPittsburgh Skydiving Jump Plane LLC · Mercer, PAN330VAlcovy Mountain Venture LLC · Monroe, GAN332DEMetro Aircraft Co · Bloomington, MNN332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCN333TLBrad And Jill Janecke LLC · Pierre, SDN33SBPittsburgh Institute Of Aeronautics · West Mifflin, PAN34CEFirst Call Home Health Agency LLC · Salem, ORN35BAC90 Air Inc · Lemoore, CAN35TVN35tv LLC · Shawnee, OKN3606TSunshine Aero Industries Inc · Crestview, FLN362MCAircraft Guaranty Corp Trustee · Oklahoma City, OKN3690FWv Gastro & Endo LLC · Wheeling, WVN3695WSuarez-Ballardo Jorge Luis · Glendale, AZN36TGRv Holding LLC · Winchester, MAN370PRPuerto Rico International Airlines Inc · San Juan, PRN377PUig Transport LLC · Raleigh, NCN3805EHollow Creek Investments LLC · Germantown, TNN38280Aerotrust Services Corp Trustee · Wilmington, DEN383ASLee Holdings & Investments LLC · Marks, MSN385EMEmerald Aviation Inc · Manassas, VAN386GABarnes Inc · Lewiston, IDN394ALTeebird Enterprises LLC · Brighton, COFirst renewal notice
Back to AD 85-01-01