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.
N4428YCherry Hill Aviation Inc · Freetown, INN4428ZRegistered aircraftN44290Fly With US LLC · Cantonment, FLN4429APrillwitz Nolan D · Appleton, WIN4429LShingebiss LLC · Independence, ORN4429PRegistration Pending · Kenai, AKRegistration pendingN4429QDyberg Mike DBA · Mount Vernon, WAN4429RMacoupin Flyers Inc · Hettick, ILN4429YBlackstone Aircraft LLC · Hartselle, ALN4429ZAerial Crop Care Co · Hebron, NDN442AAbrams Gary L · Tucson, AZN442AHFerrante Aviation Inc · Vandergrift, PAN442AKKelly Aviation Inc · Tampa, FLN442ARJax Transport LLC · Amarillo, TXN442BBMcdougall Michael D · Caldwell, IDN442BDHilton Head Helicopters LLC · Hilton Head Island, SCN442BGBowling Green Flight Center LLC · Bowling Green, OHN442BLVertical Bird Adventures LLC · Montgomery, TXN442BNParker Helicopter LLC · Watsonville, CAN442BSNext Level Capital LLC · Spring, TXN442CACoast Flight Training And Management Inc · Dallas, TXN442CBCedar Ridge Aviation LLC · Knox City, TXN442CCRaymond Andrew A · Crescent, IAN442CHHelicopter Leasing LLC · Henderson, NVN442CMAnderson Charles M Jr · Snohomish, WAN442CPEmerald City Aircraft Leasing Inc · Port Orchard, WAN442CROklahoma Aviation LLC · Bethany, OKN442DBRegistered aircraftN442DCMurray Jeffrey H · Saranac Lake, NYN442DEGlad Air I LLC · Cuyahoga Falls, OHN442DMYoung Lawrence N · Poplar Grove, ARN442DRChanging Horizons LLC · Helena, MTN442ED&S Aviation LLC · Yakima, WAN442ERChristiansen Aviation LLC · Wilmington, DEN442FAJackson Paul Douglas · Victoria, VAN442FMHogan Quinn H Trustee · Milwaukee, WIN442GRAk Air Leasing LLC · Homer, AKN442GSFly-Right Aviation LLC · Anderson, SCN442HBAirborne LLC · Wilmington, DEN442HCHigh Country Helicopters LLC · Sisters, ORN442HGGeorgia Aviation Authority · Eastman, GAN442HHSouthern Utah University · Cedar City, UTN442HLGardner Fred J · Lakewood, COFirst renewal noticeN442JEConcho Aviation LLC · Sterling City, TXN442JMStarr County Helicopter Services LLC · Mcallen, TXN442JPFix Wing LLC · Fort Lauderdale, FLN442KCAlaska Angel Aviation LLC · Anchorage, AKN442KLLedwith Kenneth E · Lincoln, CAN442KPUtah State University · Logan, UTN442KSChristiansen Aviation LLC · Wilmington, DE
Back to AD 2007-04-19 R1