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.
N2815PJohnson Trevor T · Somerset, WIN2815RKimmel Aviation Insurance Agency Inc · Greenwood, MSN2815YFlakes LLC · Fort Worth, TXN2815ZBarnhill Daniel D · Robertsdale, ALN28166Lark Thomas · Coppell, TXN28168Walker Investment Co Construction · Cookeville, TNN28169Zollars Byron · Georgetown, TXN2816GGiles Aviation LLC · Spring, TXN2816KVigna Douglas Del · Portland, MEN2816NAlford Hobart R · Palm City, FLN2816RBipes Anthony G · Forest Lake, MNN2816XCoats Christopher · Vinita, OKN28170Stracar Miro · Syosset, NYN28177Perez Philip G · Ft Worth, TXN28179Canto Aviation LLC · Buxton, NCN2817ARamey Shane · Buffalo, WYN2817C2817c Inc · Wilmington, DEN2817D2b Group LLC · West Dundee, ILN2817LHopkins Dennis L · Bark River, MIN2817RHunt Loren M · Nevada, MON28181Cheslar Aviation LLC · Lewes, DEN28189Knipe Ronald C · Orlando, FLN2818AHengemuhle Ronald J · Long Prairie, MNN2818DSlodki David · Massapequa Park, NYN2818ESale Reported · Lexington, NCSale reportedN2818FMccullough Andrew · Lubbock, TXN2818MMarotta Robert J · San Diego, CAN2818PHancock Timothy R · Malinta, OHN2818SAviator Antics LLC · Grand Forks, NDN2818TLb33 LLC · Helena, MTN2818XBarr Suzanne Renee · Cape Coral, FLN2818YEaton Melvin W II · Saint Onge, SDN2818ZJohnston Charles W C · Newfield, NJN28191Ashurst Joe D · Wheatland, WYN28195Richard C Rinks & Assoc Inc · Cookeville, TNN28199Guppy Aviation LLC · New Smyrna Beach, FLN2819DAicg Group I LLC · Sheridan, WYN2819FMacair LLC · Kennesaw, GAN2819LMason Timothy F · Effingham, ILN2819PRector David F · Akron, OHN2819QAirborne LLC · Wilmington, DEN2819TMelvin Haigis Jr · Bardstown, KYN2819XPope Steven R · Gilbert, AZN281AFState Of Louisiana · Baton Rouge, LAN281ARKing Scott · Knoxville, TNN281AWWebb Alan J · Medford, ORN281BAnderson David R · Sycamore, ILN281BGD&J Aviation LLC · Apopka, FLN281BLWingsleasing LLC · Wichita, KSN281BMMcilroy Bob · Charlotte, NC
Back to AD 2007-04-19 R1