AD 98-21-21 R1
Registered aircraft · 85,620
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:98-21-21-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
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:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') 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.
N1JQJacquot Daniel C · Colorado Springs, CON1JYRicks Electric Plus LLC · Middleton, IDN1KPSherman Loren R Jr · Granbury, TXN1KUUniversity Of Kansas Aerospace Engineering Dept · Lawrence, KSN1KYCatherines Aviation Services LLC · Sewanee, TNN1LJN1lj LLC · Edgewood, WAN1LLC&L West Coast Flyers LLC · Dixon, CAN1LPRegistration Pending · Lynn Haven, FLRegistration pendingN1LQStrydom Cornelis F · Liberal, KSN1LVMcarthur Thomas M · Annapolis, MDN1LXDix Justin T · South Boston, VAN1MEHall James C · Redington Beach, FLN1MFWise Christopher J · Plano, TXN1MPFly One Mp LLC · Omaha, NEN1MQGc4 Aero LLC · Birmingham, ALN1NMShaffer Thomas F DBA · Somerset, PAN1NTDmac Aircraft LLC · Savannah, GAN1PFTownes Patrick S · Lucerne Valley, CAN1PHRegistered aircraftN1PVMuzny Gregory · Magnolia, TXN1PZRegistered aircraftN1QABender Edward C Jr · Lansdale, PAN1QGLos Arboles Management Company LLC · Moriarty, NMN1QPN667sr LLC · Richmond, KYN1QSUniversal Investment Group LLC Trustee · La Crescenta, CAN1QYJet X Leasing Inc · Johnson, KSN1RMMeggers Roger D · Baker, MTN1RTFrost Darrell G · Atlanta, TXN1SBHattan John A · Goddard, KSN1SKWienhoff Kevin Bruce · Salem, ORN1SRRensberger Scott C · Lake Jackson, TXN1SYPacific Fleet Aviation LLC · Rochester, NYN1TAJustine Lorraine F · Newark, DEN1UGRegistered aircraftN1UKPenn Flight School LLC · Quakertown, PAN1UZJet X Leasing Inc · Johnson, KSN1VKChupito Sabrocito LLC · Paso Robles, CAN1VZKilian Michael S · Morrow, OHN1WDBushcraft Aviation LLC · Cypress, TXN1WFRegistered aircraftN1WUN1wu LLC · Loganville, GAN1WYBultron Cristina · Ocala, FLN1XSaitto Jeffrey M · Media, PAN1XACowell Aviation Maintenance LLC · Easley, SCN1XDOne X-Ray Delta LLC · Shreveport, LAN1YCMay Thomas W · Texarkana, TXN1YDBerg Bradley · Tulare, CAN1YMSupreme Aeronautics LLC · Haymarket, VAN1YRPerley Kevin G Trustee · Sioux City, IAN1YTOne Yankee Tango LLC · Jenks, OK
Back to AD 98-21-21 R1