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.
N9158HParrish Aviation Flight Academy LLC · Southlake, TXN9158VMellinger David S · Lusby, MDN9158YLockwood Rick I · Garden Grove, CAN91596West Michigan Flying Club Inc · Norton Shores, MIN9159HHess Garrett · Fullerton, CAN9159KRoss Andrew · Yamhill, ORN9159VSmith Darryl Edward · Houston, TXN915AJb Efta Farms Inc · Argyle, MNFirst renewal noticeN915AAHoecher Robert T · Anchorage, AKFirst renewal noticeN915AZN915az LLC · Miami, FLN915CMVaayu Aviation LLC · Newark, CAN915CPCivil Air Patrol Inc · Maxwell Afb, ALN915GArcher Flight LLC · Wilmington, DEN915GWWills Gary W · Channahon, ILN915JBKruger Karl A · Monterey, TNN915JDDowling Jeffrey T · Poplar Grove, ILN915KPhelps Lawrence D · Vinton, IAN915KKKramer Kurt J · Volcano, CAN915LCardinal Flying Corp · San Jose, CAN915LFLingo Joshua B · Oak Grove, LAN915MBBarras David G · Breaux Bridge, LAN915NCMiller Nevin D · Naples, IDN915PSmith Jr Franklin R · Rock Hill, SCN915PABird Acquisition LLC · Phoenix, AZN915PBLease Lawrence · Royal Oaks, CAN915RDDavis Richard L · Kenai, AKN915RSHayward Houston C · Lansdale, PAN915RVWiegand Jeffrey L · Ocean Isle Beach, NCN915TAAurora Aircraft LLC · Waterford, MIN915TTLake Elmo Aero LLC · Lake Elmo, MNN915WBBordelon Warren P · Breaux Bridge, LAN915WVSmith Aviation LLC · Springer, OKN9160DMalsby Thomas H · Blairsville, GAN9160HTodd Media Inc · Tuscaloosa, ALN9160JMohan Aditya · Rancho Cordova, CAN9160VLangis Maximus · Newburyport, MAN9161FHuie John E · Burnet, TXN9161HAir Athens LLC · Athens, GAN9161JNortheast Nebraska Aviators Inc · Wayne, NEN9161SCarr Jack Willson · East Lansing, MIN9161VKaroki Jonah · Strasburg, CON91622Utterback Karl D · Fort Wayne, INN9162HStratus Aviation LLC DBA · Vacaville, CAN9162JHillelson Lawrence E · Grosse Ile, MIN9162NMann Aviation LLC · Wilmington, DEN91631Seale Taylor Edward · Madison, WIN91634Tharp Anthony W · Charleston, WVN9163DRubbert Jan Dale · Upham, NDN9163JCavu Flight Training LLC · Freeport, MEN9163QWebb John L · Elgin, TX
Back to AD 90-04-06 R1