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.
N727DEKennett Aerospace LLC · Kennett, MON727FBBrotherton Anthony S · Pueblo West, CON727FLOgilvie Danny L · Yucca Valley, CAN727GAPreston Richard R Trustee · Albuquerque, NMN727HCMeyer Robert R Jr · Tehachapi, CAN727HSSandstar Aviation LLC · Lewes, DEN727HYTranstrum Monte Kay · Saint Charles, IDN727JBjdr Aero Corp · Wilmington, DEN727JFFlleurent John P · Stratham, NHN727JHAlbert Lea Airport Inc · Albert Lea, MNN727JWWiegenstein John H · Hansville, WAN727KRRogers Ronald J · Crystal Lake, ILN727LBMcnamee John B · Sugar Land, TXN727LDDonceel Leslie G · Murphy, NCN727LFLanier Equipment Leasing LLC · Gainesville, GAN727LGYouth & Aviation Inc · Thiensville, WIN727METruesdell Shannon · Stephenville, TXN727MFFaatz Mitchell R · Auburn, CAN727MRUnavex Inc · Pensacola, FLN727MZLmb Aire LLC · Howell, MIN727PANorat Richard N V · Kerrville, TXN727PEPhoenix East Aviation LLC · Daytona Beach, FLN727PMMiddlebrook Paul E · Penn Yan, NYN727RStyer David L · Mount Gilead, OHN727RCKelley Aircraft LLC · Weyers Cave, VAN727RDRogers Randall E · Palatka, FLN727RHRegistered aircraftN727RMMarkle Robert L Jr · Cranberry Township, PAN727RVHodge Dennis M · Marion, IAN727SFRenko Steven E · Elmira, NYN727SPElite Approach LLC · Chesterfield, MON727TDLean Aviation LLC · Saint Augustine, FLN727TGWolf Aviation LLC · Beaufort, SCN727TLLangebrake Lawrence C · Saint Petersburg, FLN727TMModesto Vapor Trails · Modesto, CAN727TSStreng Terry E · Columbus, OHN727WMMd Air Ops LLC · High Springs, FLN727WVVoelcker Wolfgang Ap · Sutter Creek, CAN727ZWBergen Brady · Junction City, KSN7280CGriff Air LLC · Aurora, ORN7280DLavin Gregory S · Chugiak, AKN7280FHarmon Sharon O · Pasco, WAFirst renewal noticeN7281DMartin Michael J · Anchorage, AKN7281JBilbrey Don R · Georgetown, OHN7281YGo For Flight LLC · Minneapolis, MNN7282JWirth Alan Patrick · Callaway, MDN7282WHoracio Marcelo Knop · Hialeah, FLN7283KTuttle Jeffery D · Victoria, TXN7284CSeed Richard J IV · Wicomico Church, VAN7284GFisher Global LLC · Faulkner, AR
Back to AD 90-04-06 R1