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.
N8558YFritsch Nathaniel · Ettrick, WIN8559CJones Donald T · Barrigada, GUN8559EFlynn Mark K · Quinton, VAN8559VHolub Mark A · Dallas, TXN8559ZMoss Aviation LLC · Howell, NJN855AVD & J Training Planes LLC · Logan, UTN855CPVector Air LLC · Erie, CON855GKUavionix Corp · Bigfork, MTN855MPPerez Mario · Oak View, CAN855PCMcalee Dennis E · Defiance, MON855REBrowne Thomas J · Grass Valley, CAN855TSSteier Tim A · Blue Earth, MNN8560CGuy James L P · Wasilla, AKN8560DMachovsky Andrew J · Mesa, AZN8560MN8560m LLC · Rehoboth Beach, DEN8561VParatus Air Inc · Auburn, INN8562DKrupinski Floyd M · Chugiak, AKFirst renewal noticeN8562FWilbur-Ellis Co · Salinas, CAN8563CPearson Ronald M · Sutton, AKN8563YJohnson Richard · Fort Lauderdale, FLN8564FRmi Air LLC · Ocilla, GAN8564NEby Leo V · Clearville, PAN8564VWarfield Gerald Alan · Saltillo, MSN8564YGingers Holdings Inc · Jacksonville, FLN8566CGamble Cody M · Palmer, AKN8566VBrown Mill Ranch LLC · Lamar, CON8566YClarke George W III · Sierra Vista, AZN8567DBelleau Thomas D · Anchorage, AKN8567VDavey Bernard V · Eagle Lake, MNN8567YJohnson Randy D · Becket, MAN8568CCavanaugh Darrel N · Wasilla, AKN8569CRudd Wayne G · Basalt, CON8569DRegistration Pending · Willow, AKRegistration pendingN8569QSkyborne Airline Academy Inc · Vero Beach, FLN8569VMachen Paul Stewart · Tallulah, LAN856DASpanaflight LLC · Puyallup, WAN856DBRobinson Scott J · Menifee, CAN856GDByrd Benjamin E · Moab, UTN856KWrong Brothers LLC · Sedgwick, KSN856KWMurphy Michael J · Mendota Heights, MNN856LSlack Troy Trustee · New Concord, OHN856NDHillsboro Aero Academy LLC · Hillsboro, ORN856PProfessional Training Aircraft LLC · Wilmington, DEN856RHWijma Alexander Sotiri · Cumming, GAN856SBWard James · Chattanooga, TNN8570CMoos Jacob W · Dillingham, AKN8570FIxi LLC · West Bloomfield, MIN8570RSkyborne Airline Academy Inc · Vero Beach, FLN8570VJ K Air Inc · Chaffee, NYFirst renewal noticeN8571VFlywyo LLC · Kalispell, MT
Back to AD 90-04-06 R1