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.
N3179FMoran Peter J · Como, MSN3179LPeregrine Aviation LLC · Oro Valley, AZN3179ULawson John A · Lott, TXN3179YWolstein Joe M · Bigfork, MTN317ACChickenhawk Inc · Wilmington, MAN317AJHibpshman Albert · Gilbert, SCN317BDRegistered aircraftN317BFBoldflight LLC · Greenwood, INN317BLCowboy Aviation LLC · Edmond, OKFirst renewal noticeN317BTAmerican Aircraft Brokers LLC · Aurora, ORN317CAspn Aero LLC · Ostrander, OHN317CDBluecore Leadership LLC · Reston, VAN317CHCrestair Air LLC · Dover, DEN317CPCivil Air Patrol · Maxwell Afb, ALN317DKKragnes David J · Felton, MNN317DSRucker Edward A · Longview, TXN317EPerkins Kevin J · Wichita Falls, TXN317EPMcelligott Michael J · Woodstock, VAN317GKPeterson Kurtley D · Centerfield, UTN317HDHardrock Drilling LLC · Francesville, INN317HMSplendid Aviation-Victoria LLC · Corpus Christi, TXN317JKKress Dagmar · Parker, CON317JRUnd Aerospace Foundation · Grand Forks, NDN317KAWycka Michelle Sarah · Stayton, ORN317LAviation Adventures And Publications Inc · Wilmington, DEN317LBTrail Of 140 Tears LLC · Bozeman, MTN317MARegistration Pending · Craig, MORegistration pendingN317RDelaney Jeffrey Stephen · Arlington, TNN317RJN317rj Inc · Maitland, FLN317RMMonaghan Robert Edward · San Bruno, CAN317RVSky Blue Flyers LLC · New Holland, PAN317SCDuehring Jonathan H · Raleigh, NCN317SDSipila Hart A · Soquel, CAN317SGGilliam Robert Lee · Tullahoma, TNN317STStewart Scott R · Cloverdale, CAFirst renewal noticeN317TMascelli John S · Hawthorne, CAN317TRRcs Aeronautical Inc · San Antonio, TXN317TWYale Companies LLC DBA · Indianapolis, INN317XBogner Matthew L · Santa Cruz, CAN317ZNew William C · Hemet, CAN318Liberty University School Of Aeronautics · Lynchburg, VAFirst renewal noticeN3180DKleimer Steve · Bozeman, MTN3180GEdwards Thomas E · Brighton, CON3180QA & L Aircraft Holding LLC · Miami Springs, FLN3180RThomas Lance E Trustee · Mesa, AZN3180UBasan Oasis LLC · Santa Teresa, NMN3180WPepe Charles · Morrisville, VTN3180YWalker Jim · Lovell, WYN3181CFour Boys Aviation LLC · Madison, MSFirst renewal noticeN3181QSpitzer Helicopter LLC · Woodland Hills, CA
Back to AD 2007-04-19 R1