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.
N38049Moore Aviation Services LLC · San Antonio, TXN3804ABig Love LLC · Tifton, GAN3804DGabbert Lucious L · Prescott, AZN3804KWebster Max S · Dalton, PAN3804MGlenmont Air LLC · Strasburg, VAN3804PMadsen Theodore W · Gillette, WYN3804QWings Over Texas Holdings LLC · Denton, TXN3804TMarello Thomas J · Westminster, MDN3804YChelmo Jed E · Kimball, SDN3804ZCulbertson William Theodore · Helena, MTN3805DThurier Lawrence V · Stevens Point, WIN3805FSmith James E Trustee · Kalispell, MTN3805NHopkins Michael P · Granbury, TXN3805PSpinner Family Lp · White City, ORN3805TEyth Isaac S · Fe Warren Afb, WYN3805YMacys Flying Service Inc · Tulelake, CAN38065Boyd David · Havasu, AZN3806FSkytours Aerial LLC · Jackson, MIN3806LPeterson Ross D · Hutchinson, MNN3806MAbbott Cedric M · Buckfield, MEN3806TFacklair LLC · Granville, OHN3806YOnion Crest Air LLC · Arcadia, NEN3806ZNamtvedt Erik · Wasilla, AKN38071Carter Donald P Trustee · Merced, CAN3807EDonaghe Larry Chance · Rockwall, TXN3807FDeno Gerald G · Battle Creek, MIN3807JJohnson Gunnar W · Wasilla, AKN3807PLuebber Jan D · Malaga, WAN3807TAmbrose Construction Ltd · Corpus Christi, TXN3807WFeller Gerald A · Long Beach, CAN3807XAlpha Bravo Lima LLC · Covington, TNN38081Heitmeier Cody F · New Orleans, LAN38082Pope Bill F · Prescott Valley, AZN38088Toledo Jorge A · Coral Gables, FLN38089Dabbs Randal L · Lenoir City, TNN3808DByrd David P · King Salmon, AKN3808FChandler Air Service Inc · Chandler, AZN3808MWings Of Clearfield Inc · Centre Hall, PAN3808QJordan Klein DBA · Summerfield, FLN3808RCatalano Joan E · Sequim, WAN3808WDodson International Parts Inc · Rantoul, KSN3809DRhoads William · Williamsburg, VAN3809MWood Robert A V · Anchorage, AKN3809TMiller Jo Ann · Atlanta, GAN3809WFair Skies Aviation LLC · Cincinnati, OHN3809XVoracek Michael G · Richardson, TXN380AURunamuck LLC · New Orleans, LAN380BFTidmore Argie D · Pottsville, PAN380BPMoe Michael J · Detroit Lakes, MNN380BTPiper Aircraft Inc · Vero Beach, FL
Back to AD 2007-04-19 R1