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.
N51JEBragdon James O · Monticello, FLN51KKFedman Ventures LLC · Sauk City, WIN51LKKroloff Logan · Seattle, WAN51LVNeal Darren I · Castle Rock, CON51MHBlock Scott M · Chandler, AZN51MJJimenez Michael G · Dayton, NVN51MSDekervor Marc Phillippe II · La Mesa, CAN51MYDrollinger David H · Kennewick, WAN51PAMichals Jeffrey J · Victorville, CAN51PCCox James M · Holly Pond, ALN51PDBcww LLC · Bakersfield, CAN51PFCarlson Arvey S · Scottsbluff, NEN51PWVerroi Timothy A · Beaufort, SCN51QTGordon David A · Sitka, AKN51RAK And D Aviation Inc · Robbinsville, NJN51RBShenk David K · Longmont, CON51RVSwiatek Glenn E · Montrose, CON51SJSmith Bradlee W · Georgetown, TXN51SMSolomon Steven D · Prospect Hill, NCN51STCnc Aerobatics LLC · Ada, MIN51SV898tx Leasing LLC · Plano, TXN51TCCurtis Ted N · Huntington, UTN51TLRegistered aircraftN51TPStewart Dale S · Las Vegas, NVN51TRRomero Anthony A · Tucson, AZN51VKGaudreau Henry J · Chesaning, MIN51WDWyatt Greg · Summerville, GAN51WEColumbia Asset Trust Corp Trustee · Wichita, KSN51WKKimbrell Kenneth W · Jasper, ALN51WT51 Whiskey Tango LLC · Henrico, VAN51XASturges George S Jr · Bakersfield, CAN520Registered aircraftN5200HIowa Lakes Community College · Estherville, IAN5200LDecker Michael · Baxter, TNN5200TUding Michael E · Sainte Genevieve, MON52012Skylens LLC · Hammond, LAN52013Hillsboro Aero Academy LLC · Hillsboro, ORN52015Gibbs Timothy L · Valley Grande, ALN52017Worringer Richard G · Tower, MNN52019Bryant Robert D · Perry, UTN5201CCordero Jose Robert · El Paso, TXN5201DGriffin Thomas S · Spartanburg, SCN5201EGholizadehkasgari Mary Ambanoo · Jacksonville, FLN5201HGorge Winds Aviation Inc · Fairview, ORN5201LMelchiorre Joseph G Jr · Milton, DEN5201NMarr Christopher M · Morrisville, NCN5201QAdams Clive P · Hendersonville, TNN5201RWest Florida Flying Service LLC · Safety Harbor, FLN5201TOwen Richard D · Ridgecrest, CAN5201UMccrary Enterprises LLC · Port Jefferson, OH
Back to AD 90-04-06 R1