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.
N3541AFogle Douglas J · Valparaiso, INN3541EClear Skies Aviation LLC · Longs, SCN3541KGauvin Daniel G · Newport, VTN3541PZang Peng · Mason, MIN3541WFlying Horsemen Aviation LLC · Lyons, MIN35420Edwards David S · Colbert, WAN35421Gleason Franklin R · Darlington, SCN35422Hamilton Pamela P · Norman Park, GAN35423Curenton Rufus B · Elmore, ALN35425Calloway Julius W III · Indianapolis, INN3542BHuddleston James A · Eloy, AZN3542KJames Anthony · Lexington, NCN3542UChristensen Paul · Granite Falls, WAN3542WRockwall 6 LLC · Royse City, TXN3542YNash Richard P · Missoula, MTN35434Chalk 2 Inc · Apple Valley, CAN3543FKorngold Brandon L · Aliso Viejo, CAN3543GAmerican Aviation Inc · Brooksville, FLN3543HMagness Thomas W · West Chester, PAN35441Boe Shay Lynn · Mesa, CON35443Registered aircraftN35446Adelman Hiram · Bass Harbor, MEN35449Whitlow Ray T · Shelbyville, KYN3544BAvcorp Holdings Inc · Jackson, MIN3544FFercho Corliss Y · Glendive, MTN3544KKelso Ted M · Fort Worth, TXN3544LLabounty Dana G · Sumter, SCN3544PClark John W · New Philadelphia, OHN3544UKarmik Aviation LLC · Fort Edward, NYN3544XKing Richard S · San Antonio, TXN3544YPeters Ben · Seminole, TXN3544ZSky Chiefs Aviation LLC · Gainesville, FLN35450Cole William A · San Francisco, CAN35454Norman Robert Alan · Zanesville, OHN35456Wing Dock LLC · Miami, OKN3545BDesert Aircraft Services LLC · Scottsdale, AZN3545DHudson Guy G · Chickaloon, AKN3545KMil2atp Inc · Pikeville, NCN35461Registered aircraftN35467Brown Wilson J · Statesville, NCN35469Oord Joshua · Moses Lake, WAN3546EDussinger Andrew M · Enola, PAN3546FN3546f LLC · Kitty Hawk, NCN3546KPrellwitz Randy · Fairbury, NEN3546NGleason John R · Yorktown, VAN3546WMelander Dan · Summit, MSN3546ZPerkins Todd M · Lake Alfred, FLN35470Lombardi Michael J · Bloomfield Hills, MIN35474Massey Shawn A · Satanta, KSN35477Schmidt Edward J Sr · North Brunswick, NJ
Back to AD 2007-04-19 R1