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.
N339CDMcwethy22 LLC · Woodstock, GAN339CHPitch And Power LLC · Indianapolis, INN339CPHenley Mark L · Emelle, ALN339DGRegistered aircraftN339DLFriedrich Robin K · Houston, TXN339EEvans James W Jr · Wake, VAN339ECBlackmore Marc A · Hilltop Lakes, TXN339GOrsolits Robert M · Maitland, FLN339JCNorman Robert Alan · Zanesville, OHN339JSMountain Taxi LLC · South Jordan, UTN339LLThro Flight Inc · Boca Raton, FLN339MEShinkle Gordon · Gillette, WYN339MKNorth Star Aviation · Mankato, MNN339MSMile And A Half High LLC · Sarasota, FLN339NDUnd Aerospace Foundation · Grand Forks, NDN339PJWallace James R · Aumsville, ORN339RVBillips Robert A · Bluefield, VAN339SABig River Farms Inc · Natchez, MSN339SCSea Seven LLC · Weatherford, TXN339SPCahill Michael · Moon Township, PAN339TLeroux Todd C · Palmer, AKN339WLawson Richard Brandon · Ararat, NCN33ANeo Terra Aviation LLC · Setauket, NYN33ADSouthern Turf Services LLC · West Palm Beach, FLN33AKMoses And Associates Inc · Gainesville, FLN33ANBarnes Gary Aaron · Huntsville, ALN33ATKrebs Bernd R · Sandwich, ILN33AVMaurer Sara Ann · Anchorage, AKN33AWWeigle Alan B · Seward, NEN33BBHendricks Timothy J · Telluride, CON33BP33bp LLC · Sand Springs, OKN33BYSellmeyer Flying Service · Knobel, ARN33CBShepperson Frank Lester · Midwest, WYN33CDElliott Kathy · South Thomaston, MEN33CLBills Jacqueline Trustee · Willard, MON33CMCharley Ernie · Gakona, AKN33CRConstitutional Defense Arizona LLC · Scottsdale, AZN33CTThree Wing Flight School LLC · Stratford, CTN33CVMaintain Aviation LLC · Pomona, MON33CXK & S Irrigation Inc DBA · Higbee, MON33DBBowers Albert Joseph Jr · Aberdeen, MDN33DHHarrington David · Lake Saint Louis, MON33DMGray Chad T · Garden Valley, IDN33DSAvion Ahoy LLC · Jacksonville, FLN33DVKostreva Adam · Riverton, WYN33ECMccammon Aviation LLC · Sullivan, INN33EEDes Moines Skydivers LLC · Des Moines, IAN33EFJarosak Theodore J Jr · Portage, INN33EJReinke Bradley H · Pascagoula, MSN33ELAdvancing Blade LLC · Glenwood, MN
Back to AD 2007-04-19 R1