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.
N3300GAir Amg LLC · Greensboro, NCN3300PDiscover Resources LLC · Norman, OKN3300YRaulston Electric LLC · Bagwell, TXN3300ZKoliastasis Pete · Reno, NVN33017Nationwide Aviation LLC · Hudson Oaks, TXN33018Lovingier Michael J · Glendale, AZN3301DJohnson Peter L · Chico, CAN3301PDramstad Flying Service LLC · Helena, MTN3301RJuliet Zulu Holdings LLC · Dover, DEN3301ZWood Paul S · Lawton, OKN3302DGeorge Clifford E · Starkville, MSN3302WKsnl Aero LLC · Shawnee, OKN3302YFoster James R · Mcpherson, KSN3302ZMeginnes Mark A · Tucson, AZN33030Fanopoulos Joshua J · Boise, IDN33031Jerpbak Mark J · El Dorado Hills, CAN3303YWoolery David W Jr DBA · Lathrop, MON3303ZZanis Paul M · Wolfeboro, NHN33046American Eagles Flying Club · New Hudson, MIN33047Meise Justin · Hopewell Junction, NYN3304BDoty Danial J · Talkeetna, AKN3304FStephan Pamela K · Anchorage, AKN3304PBucket List Aviation LLC · San Jose, CAN3304QMcnutt Brian K · Mojave, CAN3304XPhillips Daniel J · Argusville, NDN3305Erwin Matthew L · Georgetown, INN3305PAir Royal · Middletown, DEN3305RLivingston Sonja L · Redding, CAN3305YWolfe Randall S · Wasilla, AKN33061Piper 33061 LLC · Rustburg, VAN33064Facklair LLC · Granville, OHN3306CSkylane Inc · Schaumburg, ILN3306DAlquist Kevin B · Edwardsville, KSN3306EBlackwell Calvin C · Fort Worth, TXN3306UMartin Paul R Jr · Greensboro, GAN3306YSaunders Craig · Spring Hill, FLN33075Portugues Aviation LLC · Canovanas, PRN33077Klug Ryan Gregory · Lincoln, NEN33079Devaney Aviation Inc · Palm City, FLN3307PAlbano James R · Oakham, MAFirst renewal noticeN3307RPhan Tam M · Charlotte, NCN3307UPatronyk Gregory M · Santa Barbara, CAN3307WCowell Samuel · Easley, SCN3307XMathison John M · Vancouver, WAN33081Tofan Ray · Chula Vista, CAN33083Barnhill Chris · Carbondale, ILN33085Salsbery Scott E · Brush Prairie, WAN3308FBravo Hotel LLC · Lewes, DEN3308KHowell Harley L Jr · Colville, WAN3308RLocatelli Gabriel G · North Bend, OR
Back to AD 2007-04-19 R1