AD 2012-06-01
Registered aircraft · 726
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:2012-06-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-06-01')
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:2012-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-06-01') 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.
N840JSFe 5282 LLC · Kinston, NCN841DWSouth Coast Aviation Inc · Portland, ORN841JSFe Xl 5253 LLC · Kinston, NCN842AAstec Industries Inc · Chattanooga, TNN843JSFe Encore Plus II LLC · Kinston, NCN844JSFe5344 LLC · Kinston, NCN845JSThese Pretzels Are Making Me Thirsty LLC · Kinston, NCN846JSChinaberry Landing LLC · Sugar Hill, GAN847A8m Holdings LLC · Bloomfield, NEN847JSJml Jet II LLC · Uvalde, TXN850FTHuff Air LLC · Uvalde, TXN851JSFe Xl 5111 LLC · Kinston, NCN852JSFe Xls 5566 LLC · Kinston, NCN852LHKriskraft Air LLC · Orange, CAN853FCFoote Aviation LLC · Manhattan, KSN853JSFe Encore Plus I LLC · Kinston, NCN854ANYonderbyrd LLC · Hickory, NCN855ACVision Jet LLC · Fort Wayne, INN855JSFe 5064 LLC · Kinston, NCN855SCStarlight Flights Aviation LLC · Wolfforth, TXN856JSFe 5040 LLC · Kinston, NCN857CBSpm3 LLC · Phoenix, AZN857JSFe 5608 LLC · Kinston, NCN859FTMf Equipment LLC · Uvalde, TXN85HAEb Aircraft LLC · Elkhart, INN860JST&E Aviation LLC · Albuquerque, NMN860MWampatuck Aviation LLC · Marshfield, MAN863JSFe 5512 LLC · Kinston, NCN864JSJk Air LLC · Fayetteville, ARN865JSFe 5283 LLC · Kinston, NCN865TNUniversity Of Tennessee · Knoxville, TNN865UTUniversity Of Tennessee · Alcoa, TNN867JSJs Jet III LLC · Kinston, NCN867WKendall Hunt Publishing Co Inc · Dubuque, IAN868CGIrg Wings LLC · Los Angeles, CAN868CMRegistered aircraftN868JSEverything Aviation LLC · Trabuco Canyon, CAN868XLWhiskey Delta Bravo LLC · Fort Myers, FLN869JSExclusive Jets LLC · Kinston, NCN86WUUmphrey Air LLC · Beaumont, TXN8701LCitation Oil & Gas Corp · Houston, TXN870JSFe Xls 6200 LLC · Kinston, NCN871RFScheels All Sports Inc · Fargo, NDN872BBStampede Aviation LLC · Phoenix, AZN872JSSea Jay LLC · Raleigh, NCN876ADRegistered aircraftN876RAParminter Investments LLC · Wilmington, DEN876UCRegistered aircraftN877RWRed Wing Shoe Company Inc · Red Wing, MNN87BEOrion Aviation LLC · Jeffersonville, IN
Back to AD 2012-06-01