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.
N55935Teprovich Thomas J III · Peachtree City, GAN55938Turner Cole M · Round Rock, TXN5593BQualick Robert N · White Rock, NMN5593CSouth Coast Aviation LLC · San Diego, CAFirst renewal noticeN5593DOhaike Richard O · Mansfield, TXN5593PDingus Donald E Jr · Brownfield, TXN5593QBrazdys Luke V · Kingman, AZN55940Zadrick Wayne J · Bristol, CTN55942Ray Lynn M · Cloquet, MNN55948N235ml LLC · Marshalltown, IAN5594BPara-Plane Aviation Inc · Thomasboro, ILN5594CNovember Inc · Murfreesboro, TNN5594PBombo Aviation LLC · Gold Beach, ORN5594YWdw Aviation Leasing Inc · Knoxville, TNN55954Registration Pending · Jacksonville, FLRegistration pendingN55955Pierce Riley Deirdre · Chicago, ILN55958Rl Magneto LLC · Sacramento, CAN5595BLahn Dave R · Quincy, WAN5595EV & E Sunset LLC · St George, UTN5595FByrne Matthew A · West Allis, WIN5595PCassell Joseph · Singer, LAN5595QLivezey Patrick · Lithia, FLN55960Gallagher Sean · Cave Creek, AZN55965Greene County Flying Club · Waynesburg, PAN55967Hisman Gary L · Skagway, AKN55968Tindle David W · Fennville, MIFirst renewal noticeN5596BFlyventure LLC · Fort Wayne, INN5596DBas Part Sales LLC · Greeley, CON5596JJenny LLC · Hudsonville, MIN5596UPine Aviation Inc · Sheridan, WYN55970Soaring Eagle Aviation LLC · Carmi, ILN55973Crase Nicole Trustee · Mansfield, OHN55975Pena Leonardo · The Colony, TXN55977Walker Benjamin M · Weatherford, TXN55979Acumen Aerotech LLC · Rogers, TXN5597BBucher Burton W · Waukegan, ILN5597DReetz Bernard A · Discovery Bay, CAN5597FDeardorff Karl R · San Luis Obispo, CAN5597UFejor Inc · San Juan, PRN5597WLathrop Christopher A · Palmyra, WIN55986Turner Jeffrey K · Gastonia, NCN55988Murawski Rene · Clarkston, MIN5598FKeran Gary R · New Holstein, WIN5598GNorth River Investments Inc · Palmetto, FLN5598JMakfly LLC · Chardon, OHN5598UHilton Colby W · Amarillo, TXN5598WBall Dontel J · Tacoma, WAN55990Registered aircraftN-number assigned, not yet registeredN55996Mcfarlane Randall C · Loudonville, NYN5599BMccain David O · Ashville, AL
Back to AD 2007-04-19 R1