AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N429CPCivil Air Patrol Inc · Maxwell Afb, ALN429DLLandset David J · West Palm Beach, FLN429DRConard John C · Minnetonka, MNN429EGCongalton Steve M · Rancho Cucamonga, CAN429EPBbm Air LLC · Macon, GAFirst renewal noticeN429ESBarbers Point Flight School LLC · Kapolei, HIN429FFDhs Operations LLC · Wilmington, DEN429GLHamilton Verlon D · Roanoke, TXN429JPHnb Aviation LLC · Forestburg, TXN429KERegistered aircraftN429LChristiansen Aviation LLC · Wilmington, DEN429LDBonanza44 LLC · Fort Myers, FLN429MAirmart Inc · Lexington, KYN429MVSacandaga Air Inc · Fort Plain, NYN429PDupuy William C · Waco, TXN429PCShanks Charles Scott · Edmonds, WAN429PSMjk Leasing LLC · San Antonio, TXN429RTrinity Point Enterpises LLC · Odessa, FLN429RCN429rc LLC · Gladwyne, PAN429RVEvans Logan R · Livermore, CAN429SFLewis Jason M · Camden, ARN429TWWebb Thomas M · Nine Mile Falls, WAN42AAN42aa LLC · Nantucket, MAN42AGBeck William J · Phoenix, AZN42AHRegistered aircraftN42AKGerhardt David · Denver, CON42AMGruhlkey William H · Wildorado, TXN42APMontana Aircraft Trust Inc Trustee · Bozeman, MTN42ARAtlantic Aircraft Holdings LLC · Bohemia, NYN42AUBite Wing Aviation LLC · Wichita, KSN42AVIsland Aero LLC · East Northport, NYN42BDKristoferson John S · Denton, TXN42BLRainey Steven M · Rosamond, CAFirst renewal noticeN42BUUnrein Brian L · Conyers, GAN42CMMazor Chris · Belleville, MIN42CPHingst Arthur · Hermann, MON42CWHollywood Of The South Flight School Ltd · Decatur, GAN42DGHavard Gregory H · Conway, ARN42DKUltimate Answer Inc · Surfside, CAN42DQSinderson Mark P · Minnetonka, MNN42DRHeart Of Georgia Skies LLC · Wilmington, DEN42EKTrejo Joshua Scott · Reno, NVN42EMNbc Sales LLC · Somerville, TNN42EREmbry-Riddle Aeronautical University Inc · Prescott, AZN42FKWinged Ambition LLC · Chandler, AZN42FTVentana Blue LLC · Hyattville, WYN42FYSchwartz David W · Labelle, FLN42GAGuidance Helicopters Inc · Prescott, AZN42GFGillespie Dennis M · Orange Park, FLN42GMNelson Gale M Trustee · Spokane, WA
Back to AD 2007-04-19 R1