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.
N3225WCherokee Aero Group Inc · Lakeland, FLN3225YSamaritans Purse · Boone, NCN32265Norsesian Brandon · Valrico, FLN32267Top Flight Aviation LLC · Reedsburg, WIN32269Parker Air LLC · Mobile, ALN3226BSooner Aviation LLC · Norman, OKN3226JSimms Matthew · Davie, FLN3226NDeuel Justin R · Mankato, MNN3226QDenning Aviation Inc · Fort Madison, IAN3226SJones David A · Wasilla, AKN3226WAlbert James R · Corpus Christi, TXN3226YVaughn William Harrison · San Antonio, TXN32271Tylka Edward · Lockport, ILN32274Simaan Daniel · Fontana, CAN32276Price Company · Spokane, WAN3227ABoho LLC · Lewes, DEN3227CSnider Frederick A Jr · Morgantown, WVN3227E3227e LLC · Jacksonville, FLN3227GOgden Scott S · Collierville, TNN3227MParker Shon T · Wasilla, AKN3227PTucker Patricia A · Hamilton, MTN3227XSasar Inc · Wilmington, DEN32282Watson Scott E · Wichita, KSN32288Habzansky Michael E · Greens Fork, INN3228DNulsen Eric Randall · Greenbrier, ARN3228PPopejoy Marc · Fort Scott, KSN3228UTnt Rentals LLC · Wilmington, DEN3228WChris I Lee Md Inc · Rowland Heights, CAN3228XN3228x LLC · Colusa, CAN3228YFawley John M · Wisconsin Rapids, WIN32291Active Pilot Inc · Van Nuys, CAN32292Mdr Rental Corp · Ann Arbor, MIN32293Stone James B · Springfield, VAN32294Cloud Dancer Aviation Inc · Deland, FLN32296Fly South Aviation LLC · Charlotte, NCN32299Lundahl Kristina N · Windsor, CON3229GAero-Mark LLC · Winchester, KYN3229UEdwards Scott A · Lindsay, CAN322ALHawaii Pacific Aviation Inc · Kailua Kona, HIN322ASHenning Kurt D · Auke Bay, AKN322ATAbkadirov Tagir · Tampa, FLN322BFVann Russell B · Mangum, OKN322BWRobl Christopher · Littleton, CON322CARoyal Majesty Aviation LLC · Atlanta, GAN322CDGnc Industries Inc · Pocahontas, ARN322CHRayworth Lyle D · Carrollton, GAN322CSGlembot Troy M Trustee · Winchester, VAN322CTGrover Michael P · Palm Coast, FLN322CWGallagher Maria J · Lakewood Ranch, FLN322DRMcgrath James T · Campbell, CA
Back to AD 2007-04-19 R1