AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N887KJCf Aviation Trust LLC Trustee · Wilmington, DEN887PMHarris William M · Radford, VAN887QRCornford Craig H · San Diego, CAN887WCGalindo Don R Jr · Walnut Grove, CAN8880LMellanby Nicholas S · Saint Louis, MON8880NAnderson Aviation LLC · Bulverde, TXN8880SJohnson Kenneth E · Mahtomedi, MNN8880YPlane Fun Inc Tr Trustee · Snellville, GAN8881CMcintosh Ronald J · Walker, WVN8881VLien Ronald N · Gilford, NHN88827Hallum Randal S · Wewoka, OKN88828Yon Joseph W Jr · Pendeleton, SCN8882ERandall Christopher D · Northridge, CAN8882FCirrus Services Inc · Fargo, NDN8882JWisian Hans C · Boerne, TXN8882LRegistered aircraftN8882VTop Aircraft Leasing LLC · Wilmington, DEN8883Harris James H · Gardner, KSN88838Flyers Park Farm LLC · Newark, OHN8883CBall Travis W · Aleknagik, AKN8883JRegistration Pending · Midlothian, TXRegistration pendingN8883NWarner Alexander Douglas · Grand Rapids, MIN8883YYank N Bank LLC · Greeley, CON8884CHartman Linda C · Malin, ORN8884DJ C Aero LLC · Yelm, WAN8884NDubois Jerry · Oklahoma City, OKN8884YFlight Logistics LLC · Westerville, OHN8885HHoughton Patrick K · Villa Rica, GAN8885JWeise David D · Marion, TXN8885YWilson Cecil · Lithonia, GAN8887CHorinek Troy C · Goodland, KSN8887FNiec Steven M · Clio, MIN8887JWeskap LLC · West Grove, PAN8888JSnapp Steve J · Los Alamos, NMN8888LDorian Paul Joseph · Auburn, WAN8888NGibson Edward J · Marmora, NJN8888SStrizki Brian J · Flemington, NJN8888YPriebe Rodney M · Wasilla, AKN8889EWestern New York Flying Club Inc · Bowmansville, NYN8889VGarcia Hector A · Caguas, PRN888ADAlirio Land Services · Miami Gardens, FLN888AGKlingensmith John R · Santa Maria, CAN888APAnderson Scott · Edgartown, MAN888AWCag International Inc DBA · Longmont, CON888BMDeverapalli Vishnu Reddy · Duluth, GAN888BSFrasca Thomas W · Champaign, ILN888BWAero Elite Inc · Wilmington, DEN888CBBenz James E · Pittsford, NYN888CCStevens Terry L · New Plymouth, OHN888CFJph Aviation LLC · Pittsburgh, PA
Back to AD 90-04-06 R1