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.
N609DJDelta Juliet Holco I LLC · Ocoee, FLN609FAStratus Air LLC · New Castle, DEN609FTFlorida Institute Of Technology · Melbourne, FLN609HZRegistered aircraftN609NRoussopoulos Gary L · Santa Cruz, CAN609SCFf22 LLC · Scottsdale, AZN60AHAngelina Aviation LLC · Lufkin, TXN60ATOconnor Lloyd T · Dillingham, AKN60BLonghorn Leasing LLC · Anchorage, AKN60BEGunn Glenn R · Clearwater, FLN60BZNxbz Aircraft Holdings LLC · Broussard, LAN60CESmith Matthew J · Louisville, KYN60DVDelta Victor LLC · Plano, TXN60FXAmeriflight Management Services Inc · Orlando, FLN60GAGlidewell Aviation Inc · Parkland, FLN60GLMiko Pawel Marcin · Santee, CAN60GZAbl Aviation Inc Trustee · Wilmington, DEN60HEagle Flight Squadron Inc · East Orange, NJN60HASteeneck Robert T · Washougal, WAN60HFTexas Flying Club Inc · Bryan, TXN60HUOne Pft LLC · Denton, MTN60HYAnderson James D · Russell, KSN60JBHarmon Eagle LLC · Albuquerque, NMN60JKHiner Kirk J · Kenyon, MNN60KDBegeman Daniel L · Littleton, CON60KRRhea Keith H · Peck, KSN60LGEgmond Aircraft LLC · Lewes, DEN60LRBlake W Preston · Gainesville, FLN60MMBergeson John · Rhome, TXN60MRHansen Charles R · Covington, TNN60NAHampden Aviation Services Inc · Northampton, MAN60NCBalsley Matthew · Rowlett, TXN60NKKirchhoefer John D · Orlando, FLN60RGodette James R · Scottsville, NYN60RBShrode Rafe C · Jewett, TXN60RTPaap Patrick · Menifee, CAN60SSDhone Shridhar · Livermore, CAN60SXDitzler Enterprises Inc · Grinnell, IAN60WEVeillon Joseph B · Alexandria, LAN60WMSmith Ted J · Lakeland, FLN60WRAmbush One LLC · Memphis, TNN60WWMorton Ronald S · Seguin, TXN60XTMorgan Cody D · Portage Des Sioux, MON60YGLindstrom Dave C · Marinette, WIN60ZYBrewer Terry P · Oakland, IAN6100DSzostak Edward M · San Diego, CAN6100JFranklin County Flying Club Inc · Turners Falls, MAN6100PSuarez-Alicea Jorge A · Enterprise, ALN61011Inter American University Of Puerto Rico · Bayamon, PRN6101DHanson John A · Molena, GA
Back to AD 90-04-06 R1