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.
N597TTTerrell David R · Smithville, TNN597WBaccas Christopher · Sun City Center, FLN5980UT A Aviation LLC · Tucson, AZN5980WCooke Carole J Trustee · Aguila, AZN5980ZOyster Flite Investments Inc · Wilmington, DEFirst renewal noticeN5981DPrecision Ag LLC · Kenmare, NDN5981LAnthony Allen J · Commerce Township, MIN5981STucker Mark R · Williamsburg, VAN5981UEast Sun Corp · Greensboro, NCN5981WLudwing Jonathan · Tompkinsville, KYN5981ZFell Donald M Trustee · Homer, AKN5982HClipper New Mexico LLC · Albuquerque, NMN5982SPercy Gary A · Wedderburn, ORN5982UCapital Aviation LLC · Fuquay Varina, NCN5982WHarris Chad A · Hamilton, ALN5983DGoodell Rebecca S · Sedro Woolley, WAN5983HMccormick Michael V · Waller, TXN5983LWatson Thomas M III · Lampasas, TXN5983MPhilipp Michael W · Thief River Falls, MNN5983USale Reported · Adelanto, CASale reportedN5983WAnderson Kerri · Frazier Park, CAN5984HJohnston Brian J · Ironwood, MIN5984QSlow Walkin Barnstormers LLC · Frostproof, FLN5984SBoswell Kurt R · Renton, WAN5984UDenton Richard A · Plant City, FLN5984WN4036r LLC · Quinton, ALN5985QInderkummen Jean Pierre · Gulfport, MSFirst renewal noticeN5985WSterling West Corp · Camden, DENon-citizen corporation, flight hours not reportedN5985XWestern North Carolina Air Museum · Hendersonville, NCN5985ZHinds Clinton W · Kasilof, AKN5986LJilot Richard F · West Monroe, LAN5986QFord Christopher D · Brunswick, GAN5986UHolt Drew R · Lake Jackson, TXN5986WActon David D · Thousand Oaks, CAN5986XPanella Benjamin · Wampum, PAN5987HFarrell Tom · Sterling, AKN5987QHardesty William A · San Diego, CAN5987UBergquist Carol F · Saint Paul, MNN5987WWilson Brandon · Bozeman, MTN5988DNewburg Lyle X · Sparta, WIN5988QLynn Seth D · Killeen, TXN5988UPayan Oscar A · Teaneck, NJN5988WWest Central Aviation LLC · Prinsburg, MNN5988ZStevenson William E · Sutton, AKN5989DBoss Kevin J · Coventry, RIN5989MJohnson Dean M · Hamden, CTN5989WSmith Kevin L · Peachtree City, GAN598APiper Archer Three LLC · Wilmington, DEN598NDBremfour Aviation Group Inc · Wilmington, DEN598SCSpartan Education LLC · Tulsa, OK
Back to AD 90-04-06 R1