AD 2007-24-13
Registered aircraft · 4,026
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-24-13')
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-24-13')
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-24-13') 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-24-13') 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.
N407CDKelly George Sumner · Columbus, GAN407KPDelta Consulting & Real Estate LLC · Manila, ARN407ST5x Sr22 LLC · Sandy Springs, GAN408CDKc Jet Sales LLC · Scottsdale, AZN408KMRivers Aviation LLC · Houston, TXN408PGJs Extra 300 LLC · Dallas, TXN408RFFogel Services Inc · Ladson, SCN408WGBlue Sky 408 LLC · Lakeland, TNN409CDArmbruster LLC · Amherst, OHN40GDSimply Living LLC · Fort Myers, FLN40YMN40ym LLC · Mattituck, NYN410MPGulf Horizon Ventures LLC · Tampa, FLN410PPAircraft Guaranty Corp Trustee · Oklahoma City, OKN410SRBiondich Amy · Rubicon, WIN410VVDaniels Mark A · Raleigh, NCN411APN411ap LLC · Independence, KSN411BJclm Aviation LLC · Atlanta, GAN411DTSliwa Kevin Joseph · Fishers, INN411EPRsbrm Aviation LLC · Lakewood, NJN411EWC B Saunders Properties LLC · Alpharetta, GAN411GTTeam 646 LLC · Jupiter, FLN411HZCedar Dix LLC · Lancaster, KYN411MARouse William J · Palm Springs, CAN411PKC C Owen Tile Co Inc · Jonesboro, GAN411SAMasdon Aviation LLC · Guntersville, ALN411SKRiverside Aviation LLC · Fernandina Beach, FLN411SRC1n Cirrus G3 LLC · Rockford, ILN411VTFletcher Holdings Of Nc LLC · Winston Salem, NCN4122PCloud Eight LLC · Los Altos, CAN412CPSevern Aviation LLC · Richmond, VAN412DJStringfield Lisa P · Los Alamos, NMN412JJSkybird Aviation LLC · Bowling Green, KYN412PGVisual Approach LLC · Vienna, VAN412SRHealing Waters Counseling Center LLC · Cedar Bluff, VAN412TKBaerresen Drake A · Corona, CAN413AKAlhambra Aviation LLC · San Mateo, CAN413CNOa2 Aviation LLC · Gallatin, TNN413CPDean Taylor LLC · Palm Coast, FLN413PTag Aviation LLC · Larwill, INN413RSStewart Rentals LLC · Tampa, FLN413SRBroussard Knoll Law Firm LLC · Marksville, LAN413TLSnapper Kai LLC · Kerrville, TXN4141TPremier Properties And Investments LLC · Tarkio, MON4141XSpuddy Properties LLC · Leclaire, IAN414CKN414ck LLC · Tacoma, WAN414CPCsu Aviation LLC · Plainfield, INN414TXKwb LLC · Dover, DEN415BBAventra Aviation LLC · Fuquay Varina, NCN415GEN415ge LLC · Wilmington, DEN415GFSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 2007-24-13