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.
N5329PSpectrum Communications Inc · Moses Lake, WAN5329SAlabama Forestry Commission · Montgomery, ALN5329WShamasna Rami · Homer Glen, ILN5329YFlying Fish Ranch 29y LLC · Leesburg, FLN532BDSam Aviation LLC · Long Beach, CAN532CHall Brian · Yuma, AZN532CACulebra Aviation & Services LLC · San Juan, PRN532CHWhedbee Donald Justin · Conroe, TXN532CMRed Land Holdings LLC · Fayetteville, GAN532DBell Marvin III · Mansfield, TXN532DCDc Aviation LLC · Panama City, FLN532DGRio Farms LLC · King City, CAN532EBlue Pointe Aviation LLC · Valparaiso, INN532EBJeb Air LLC · Waverly, OHN532EREmbry-Riddle Aeronautical University Inc · Prescott, AZN532FLCleared Skies LLC · Heber, AZN532GMsd Sales Inc · Cedar Rapids, IAN532JHBobiak James R · Deary, IDN532JTSowards David · Savannah, GAN532MTalovich Michael E · Farmington, NMN532NDAia Bravo LLC · Henderson, NVN532PPenco Aviation LLC · Anchorage, AKN532QRoush James L · Medina, WAN532RRRegistered aircraftN532SHStauffer Todd L · Burley, IDN532TBosse Don R · Bellville, TXN532TWRooplal Robby Ashram · Spring, TXN5330EKrieger Andy G · Katy, TXN5330LDavenport Ross K · Raleigh, NCN5330NMarion Michael · Canyon Country, CAN5330PNielson Rex W · Pendleton, ORN5330UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILFirst renewal noticeN53310Lucente Michael A · Fort Myers, FLN53315Denton Aerial Spraying · Las Animas, CON5331DPurdue Aviation LLC · West Lafayette, INN5331EMangum Contracting Inc · El Dorado, ARN5331FGeorge Walker Field Inc · Bedminster, NJN5331GAero Tech Services Inc · Lititz, PAN5331KChristiansen Aviation LLC · Wilmington, DEN5331LKeneston Mark · Ballston Spa, NYN5331NUniversity Of Illinois · Savoy, ILN5331SGulley Christopher B · Bridgeport, ALN5331TGilchrist William J · Hodges, SCN5331WCampbell Paula J · Stanfield, NCN5331YHillsboro Aero Academy LLC · Hillsboro, ORN53323Chester Charter Inc · Chester, CTN5332AGrimes & Associates LLC · Wolfforth, TXN5332DLeibovitz Joshua · Portland, ORN5332LWings Over L A Aviation LLC · West Hills, CAN5332PLarsen Joseph · Pittsburgh, PA
Back to AD 2007-04-19 R1