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.
N34TGTri W Inc · Shepherd, MTN34TLAmeagle Aviation LLC · Coventry, CTN34TW34 Tango Whiskey LLC-S · Carmel, INN34TXMccormack Robert · Reno, NVN34UAInternational Air Services Inc Trustee · Carson City, NVN34VBBarrett Victor L · Sevierville, TNN34VFRomag Air Services Inc · Mc Lean, VAFirst renewal noticeN34VMRoberts Glenn T · Port Orange, FLN34VTLloyd Charles · Locust Grove, GAN34VVWattum Investments LLC · Kodiak, AKN34VWGalloway Chris · Jordan Valley, ORN34VYTrident Aircraft Inc · Easton, MDN34WMcinturf Ty A · Midland, TXN34WBConnolly Marc R · Littleton, CON34WCVanguard Squadron Inc · Tea, SDN34WEWildes Thomas O · Chippewa Falls, WIN34WHCarriere Trevor · Phoenix, AZN34WJShaffer Jack W · Ozark, ARN34WTT & S Aviation LLC · Lavonia, GAN34WWChute Aviation LLC · Prescott, AZN34WYDouglass James D · Berthoud, CON34XSalter Phillip G · Beaumont, TXN34XAVectored Solutions Inc · Everett, WAN34XDAnderson Aviation Inc · Anderson, SCN34XXBallance Harry Greene Jr · Atlanta, GAN34YKHood Frank A · Burlington, NCN34YNFulper Lester D · Clearwater, FLN34ZZRiggs Donald L · Asbury, NJN35008Miga Holdings LLC · Flower Mound, TXN35009Handrahan Sara J Trustee · Osceola, WIN3500MNagy Sandor · Monterey, CAN3500WAerotyne International LLC · Prattville, ALN3500YTuff Aviation LLC · Belmont, MIN3500ZKuyk William P Sr · Holly, MIN3501Jones Daryl L · Spokane, WAN35012Hayes David N · Essex, CTN35013Vitek David Carl · Franksville, WIN35018Four Two Foxtrot Inc · Vadnais Heights, MNN3501PSjoberg Leonard C · Okemah, OKN3501RStanislaus County Sheriffs Department · Modesto, CAN3501UN3501u LLC · Tulsa, OKN3501WObrien Matthew A · North Platte, NEN3501XRoark Ken W · Cisco, TXN35022Berg Christopher N · Gainesville, VAN35026Caraballo Robert · West End, NCN3502FLange Clifton E · Inez, TXN3502LNatale William F · Saratoga Springs, NYN3502MRyskoski Randall J · Germantown, WIN3502UStreamline Business Management · Citrus Heights, CAN3502WN3502w LLC · Stephenville, TX
Back to AD 2007-04-19 R1