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.
N4860WHershorin Mason P · Pembroke Pines, FLN4860YAerial Banners Inc · Pembroke Pines, FLN48616Hall Stanley C · Sequim, WAN4861ARubbert Randy C · Reynolds, NDN4861DThornquist Robert K · Anchorage, AKN4861GFlying Colors Airparts Inc · Leesburg, FLN4861LPodolinski Frank · Greensburg, PAN4861SMidwest Airmotive Inc · Mount Sterling, KYN4861UGoodmanagement Healthcare Inc · Chandler, AZN4861VRegistered aircraftN4862DHixson G C · Readyville, TNN4862EGyuro Stephen Douglas Trustee · Benton, KSN4862JWicker Gregory B · Irmo, SCN4862LGunter Gordon D · Green River, WYN4862UDodson International Parts Inc · Rantoul, KSN4862YKohler Richard L · Moriarty, NMN4863ARud Alexandra E · Clara City, MNN4863BBeach Travis W · Bishop, CAN4863LZimmerman Marlin · Muscoda, WIN4863QKlamar Spraying Inc · Gatzke, MNN4863SHogs LLC · Georgetown, SCN4863TM & M Light Transportation Co Inc · Duluth, MNN4863USpot Aviation LLC · Nevada, IAN4864DChiota Aviation LLC · Waco, TXFirst renewal noticeN4864FFreely James John · Marshall, VAN4864GLazy Eights Holdings LLC · Greenwood, INN4864LRegistration Pending · Boone, NCRegistration pendingN4864YWilliams R E · Fort Walton Beach, FLN48652Lorenz John C · Edgewood, NMN4865DBlack Hound Aviation LLC · Austin, TXN4865PThundersky Farms Inc · Helena, MTN4865SBowman Steven R · Manteo, NCN4865UMajor Richard L Jr DBA · Hickman, KYN4865VWoltjer Richard J · Pennock, MNN4866DBetts Thomas L · Fort Collins, CON4866HHolbrook Andrew L · Burgaw, NCN4866KNavion Aviation LLC · Littleton, CON4867DFlynn Brian · Auburndale, FLN4867JNational Aero Services LLC · Helena, MTN4867KMark Thomas Productions LLC · Ketchum, IDN4867L23 Right LLC · Kalispell, MTN4867UFeyen Richard F · Kaukauna, WIN4868AKlokner James B · Madison, WIN4868EVero Technical Support Inc · Pensacola, FLN4868JFoster Milton F · Dawson, GAN4868LWinningham Matthew P · Prattville, ALN4868NWisner David · East Hampton, NYN4869ANevill Bernard L · Clare, MIN4869CBerry Matthew G · Creedmoor, NCN4869DCutler Donald R · Bolivar, MO
Back to AD 2007-04-19 R1