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.
N4692JDingbat Ltd · Wilmington, DEN4692NWilliams Douglas J · Bristol, NHN4692QZulu Aircraft Leasing LLC · Grants Pass, ORN4692RKaresh Eli · Orlando, FLN4692YBillingsley Robin Trustee · Chugiak, AKN4693BSutton Aircraft Salvage LLC · Palmer, AKN4693D4 Knots LLC · Flower Mound, TXN4693EJayo Construction Inc · Boise, IDN4693JThibodeaux Gerald J · Duson, LAN4693QSievert David M · Santa Cruz, CAN4693YKnutson Wayne R · Thompson, NDN46941Haynes Aviation LLC · Caruthersville, MON4694GRegistered aircraftN4694RKent Adam · Rogersville, MON4694SRegistered aircraftN4694YKempton Chevrolet Buick Ltd · Safford, AZN4694ZKyro Consulting LLC · Williamsburg, VAN4695AAgarwal Ravi · Bath, PAN4695JGrimm Jason Eddison · Sacramento, CAN4695RDestination Flyer LLC · Memphis, TNN4695SDavis Lawrence E · Melbourne, KYN4695YSnider Scott E DBA · Turner, MTN46962Soto Del Carpio Nhikitoa · Fairbanks, AKN4696ASokol Dennis A · Milan, OHN4696DWings Of Hope · Skiatook, OKN4696FTorres Roberto · Bavamon, PRN4696JRegistered aircraftN4696K96 Kilo LLC · Modesto, CAN4696LKoontz Marina M · Seattle, WAN4696PPolhemus Christopher · Carmichaels, PAN4696RSchroter Jon A · La Crosse, KSN4696THess Aero Corp Inc · Huntsville, ALN4697KMorgan James D · Denali Park, AKN4697RHolthaus Cody · Eden Prairie, MNN46983Smale Christopher Cotrustee · Bakersfield, CAN4698C98 Charlie LLC · Anchorage, AKN4698DDrm Aviation LLC · Glencoe, ALN4698FSmith Marciano S · Fort Lauderdale, FLN4698JShea William Preston · Franklin, TNN4698KRegistered aircraftN4698RCorl Jason · Stanton, CAN4699AReed Aviation LLC · Pearl, MSN4699FStinson Ryan · Eagle, IDN4699JBeach Robert E · Fairfax, VAN4699PGv Air Inc · Medford, ORN4699RGillis Jeremiah · Cody, WYN4699SStrike Allen P · Flint, MIN4699UValdez David M · Shady Shores, TXN4699WN4699w LLC · Rutherford, CAN4699YSandhill Soaring Club Inc · Brighton, MI
Back to AD 2007-04-19 R1