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.
N477CHCsi Flight Services LLC · Mcminnville, ORN477DCChildress David W · Coldwater, MSN477DKPhilippi Ranches Inc · Hermiston, ORN477LLLima Lima LLC · Lander, WYN477LMStampley Michael C · Mount Pleasant, SCN477MERegistration Pending · Webster, NYRegistration pendingN477PCSaint Louis University · Saint Louis, MON477PSSilver Patrick F · Toney, ALN477RVVans Aircraft Inc · Aurora, ORN477SPRegistration Pending · Leesburg, VARegistration pendingN477TPaetzold Benjamin T · Fort Worth, TXN477UCWeber Jennifer R · Bryan, TXN47808Colgan Aviation LLC · La Crosse, WIN4780APenn Flyers LLC · Greensburg, PAN4780ECarolinas Aviation LLC · North Myrtle Beach, SCN4780JItzchak Arzt · Sarasota, FLN4780LLemon Kyle · Santa Ynez, CAN47818Fischer Scott R · Spanaway, WAN47819Candace A Larned Enterprises Inc · Long Beach, CAN4781JWyatt Steven Joseph · Caddo Mills, TXN4781LPhillips James W · Lancaster, SCN4781ZM Forden LLC · Pana, ILN47820Vascular Wings LLC · Friendswood, TXN47824Morris-Reade Jeffrey M · Blaine, WAN4782GSeguin Elliot · Rosamond, CAN4782RSchulert Peter A · Lebanon, TNN4782TJordan Kevin · Brookline, NHN4783Haire Kenneth H · Star City, ARN47833Rtt Aviation LLC · Columbus, NEN47835Paddock Andrew S · Ainsworth, NEN47837Kolek Kirk A · Marion, IAN47839Ohara Daniel J · Naknek, AKN4783LSikka Dhruv · Lutz, FLN4783PBush Robert Edward · Mead, WAN4784AFox Aviation International Inc · Justin, TXN4784EPeabody Jeffery L · Vinemont, ALN4784GShinn Steven M Allen · Larkspur, CON4784HKjeldgaard James K · Fremont, NEN4784JSale Reported · Crystal, MNSale reportedN4784LDelta Sierra LLC · Naples, FLN4784VFlying Acres Flyboys LLC · Milwaukee, WIN47856Vector-USA LLC · Olive Branch, MSN4785BBravo Zulu Aviation LLC · Torrance, CAN4785FSoaring Society Of Boulder Inc · Boulder, CON4785LTranswestern Air Service Inc · Golden, CON4785ZMeigs David C · Phoenix, AZN47868Heartland Airplanes LLC · Olathe, KSFirst renewal noticeN47869N47869 LLC · Spanish Fork, UTN4786ETu Erik S · Pasadena, CAN4786LZayas Omar · Fontana, CA
Back to AD 90-04-06 R1