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.
N299FCFeather Flight Aviation Inc · Warwick, NYN299HCJefferts Steven R · Longmont, CON299HEHeli 44 LLC · Freeland, MDN299HPAir King Transports LLC · Helena, ALN299JBShelton Greg N Trustee · Collinsville, OKN299JNSpell Harry · Oregon, ILN299JPSmith Cindy · Eagle, IDN299JSBrolan Aviation LLC · Kansas City, MON299JWRas Aviation LLC · Elyria, OHN299KAir Transport LLC · Troy, MTN299KDSouthern Utah University · Cedar City, UTN299KJN299kj LLC · Auburn, WAN299LRed Willow Aviation & Spraying Inc · Mccook, NEN299LCFlight Contract Services Inc · Las Vegas, NVN299LG2 Huskies LLC · Sheridan, WYN299MPayne Michael Allen · Montgomery, TXN299MPHessjet LLC · Mc Donald, TNN299NDNational Training 1 LLC · Wilmington, DEN299PAH & H Aviation LLC · Dunn, NCN299PKRegistered aircraftN299PMFailte Aire LLC · S Abingtn Twp, PAN299PTWright W Gregory III · Kinsale, VAN299PWStanley Craig M · Campbell, CAN299RFChasteen Jerry · Nashville, INN299RMGulf Atlantic Airways Inc · Gainesville, FLN299RVLawhon Daniel Lee · Corpus Christi, TXN299SAEnterprise General Aviation Network Inc · Dell Rapids, SDFirst renewal noticeN299TCBerg Ted D · Mabelvale, ARN299TXHaecker H Ivan · Canyon Lake, TXN299WAccelerated Information Technologies Inc · Gates Mills, OHN29AHRiseaero LLC · Florence, SCN29AKNavas-Prieto Angel · Starke, FLN29AMSkywave Aviation Partners LLC · Moultrie, GAN29APItzkowitz Arnold · Selbyville, DEN29ATLofton Joseph L · Huntsville, ALN29BEAltaii Ali · Gibraltar, MIN29BJMax Total Time LLC · Lufkin, TXN29BLKozura Ronald J · Pine Grove, PAN29CCSafford Aviation Service Inc · Coolidge, AZN29CPClifford Robert J · Dania Beach, FLFirst renewal noticeN29CRRegistration Pending · Cypress, TXRegistration pendingN29CSKntj Properties 1 LLC · Wildwood, MON29DAJones David W · Carlisle, PAN29DCDwlg Aviation LLC · Rogers, ARN29DLCrouch David T · Asheville, NCN29DMTimberlake Abigail · Eagle, CON29DWDusel Jason J · Blue Rock, OHN29DZHotel Charlie LLC · Lewes, DEN29EALorimor Thomas T · Sidney, IAN29EDWillard Edward J · Roy, UT
Back to AD 2007-04-19 R1