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.
N3326TGallman Doug M · Port Orange, FLN3326WSair LLC · Natchitoches, LAN33277Niebuhr Bradley A · Morriston, FLN3327DWelborn Mark G · Boonville, NCFirst renewal noticeN3327GWhitewater Aviation Inc · Harrison, OHN3327MNearhoof Jeremy R · The Woodlands, TXN3327PNewsome Charles Robert · Villa Rica, GAN3327RLyman Gregory A Trustee · Traverse City, MIN3327SDavis Blake A · Bellevue, TXN3327TFriedl Robert Stephen Jr · Mammoth Lakes, CAN3327WBlacker James Darwin · Meridian, IDN3327XTrimble Anthony W · Weatherford, TXN3327ZMessinger Donald C · Wasilla, AKN3328DAcme Aircraft Leasing Mt LLC · Kalispell, MTN3328ENorthwoods Air LLC · Orono, MEN3328QEastman John T · Winfield, KSN3329DWarren Mark W · Arlington, WAN3329FFerguson Ryan L · Fort Collins, CON3329MMcleod Michael R · Inlet Beach, FLN3329PStradley Anna M Trustee · Bozeman, MTN3329UDirectional Holdings LLC · Missoula, MTN3329VMcmahon Jeffrey J · Paris, KYFirst renewal noticeN332BGBowling Green Flight Center LLC · Bowling Green, OHN332BLLatorre Bruce M · Ferndale, CAN332CBFlying Pigs Aviation LLC · Los Altos, CAN332CDDuggar Aviation LLC · Springdale, ARN332CPCivil Air Patrol · Maxwell Afb, ALN332CVYates Philip Arthur · Allen, TXN332DGRaymond Jeffrey R · Fairbanks, AKN332DPNegley Neil C · Newburg, PAN332DWWeddle Scott · Prineville, ORN332FKukowski Raymond N · Anchorage, AKN332HPDolan Charles A · Augusta, GAN332JBMcalee Jeremy D · St Johns, FLN332JRAdair Lawrence L Jr · Fountain Run, KYN332LMLumbra Ronnie E · Rye, NYN332MCClover Park Technical College · Lakewood, WAN332MDGuidance Helicopters Inc · Prescott, AZN332NDRapier Kenneth · Chicago, ILN332RTMcelroy Scott R · Saint Matthews, SCN332RVFeijo Paul H · Tulare, CAN332SCSilver Creek Aviation Services · Fort Worth, TXN332SPMh Aviation LLC · Foster City, CAN332WBLyle Ronny D DBA · Como, TXN332ZBrown Kenneth L · Conroe, TXN33304Ellis Tom J · Chandler, AZN3330DState Of Alaska · Kodiak, AKN3330EJarco Air LLC · Fitchburg, MAN3330FEmk Trans LLC · The Dalles, ORN3330JDownwind Three Six LLC · Murfreesboro, TN
Back to AD 2007-04-19 R1