Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,433

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

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

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.

N2131TMullin Thomas F III · Birmingham, ALBuilt 1971 · S/N 28R-7135111 N2131UAgh Property Investments Inc · Key West, FLBuilt 2003 · S/N 18281227 N2131WRussek Rick · Cave Creek, AZBuilt 1974 · S/N M-1506 N2131ZAllen Travis · Newport, MEBuilt 1982 · S/N 18268165 N21320Diehl Rodney L Trustee · San Jose, CABuilt 1974 · S/N 17263929 N21321Bell Robert A · Las Vegas, NVBuilt 1974 · S/N 17263930 N21323A2t Guys Aviation LLC · Williamston, MIBuilt 1978 · S/N 28-7916033 N21326Ttf Flying LLC · Anderson, SCBuilt 2007 · S/N 18281897 N21328Endler Harold A · Black Mountain, NCBuilt 1972 · S/N 18261563 N21329Propeller Enterprises LLC · Gilbert, AZBuilt 1974 · S/N 17263931 N2132FHitchcock Wayne · Shelbyville, TNBuilt 1964 · S/N U206-0332 N2132JHolley William M · Rock Port, MOBuilt 1978 · S/N 28-7990216 N2132LCsrh Ventures LLC · Lubbock, TXBuilt 1976 · S/N D-9923 N2132RSifsof Victor G DBA · Anchorage, AKBuilt 1964 · S/N 18255332 N2132TMatejcek Lina M · Owatonna, MNBuilt 1971 · S/N 28-7125448 N2132WWheeler Equipment Leasing LLC · Gainesville, GABuilt 2003 · S/N 172S9421 N21331J-Air Eagle LLC · San Antonio, TXBuilt 2007 · S/N 18281898 N21332Celmer Charles A · Puyallup, WABuilt 1972 · S/N 18261566 N21333Melius Ray D · Erda, UTBuilt 1972 · S/N 18261567 N21338N21338 LLC · Amarillo, TXBuilt 1972 · S/N 18261571 N21339Pilots Flying School LLC · Englishtown, NJBuilt 2003 · S/N 172S9551 N2133GPrice Bradley E · Sacramento, CAS/N 51433 N2133JHoosier Aviation LLC · Terre Haute, INBuilt 1978 · S/N 28-7990217 N2133LGietzen Jeff · Seattle, WABuilt 2003 · S/N 18281287 N2133RLewis Christopher S · Hancock, MIBuilt 1964 · S/N 18255333 N2133WBeck Robert M · Bakersfield, CABuilt 1974 · S/N CE-502 N21343Bulger Thomas R · Oak Harbor, WABuilt 1972 · S/N 18261575 N21344Skylane Therapy LLC · Nampa, IDBuilt 1972 · S/N 18261576 N21347Kessler Frank J Jr · Gallatin, TNBuilt 1974 · S/N 17263933 N21348Nri Flying Club Inc · Walnut Creek, CABuilt 1972 · S/N 18261578 N2134DRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1978 · S/N 28-7916144 N2134ERice Larry Anthony Trustee · Yucaipa, CABuilt 1978 · S/N 28-7990180 N2134JMcmahan Michael Anthony · Dunwoody, GABuilt 1978 · S/N 28-7990218 N2134LHeyen John M · Springfield, ILBuilt 1976 · S/N E-890 N2134MChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9552 N2134RVanek Peter · Sedona, AZBuilt 1969 · S/N 28-5467 N2134SC Squared Inc · Stevensville, MDBuilt 1979 · S/N R18201307 N2134TBartow Municipal Airport Development Authority · Bartow, FLBuilt 1971 · S/N 28R7135142 N2134UDean Steel Buildings Inc · Fort Myers, FLBuilt 1982 · S/N 21064775 N2134WJustison David L · Hillsboro, ILBuilt 1974 · S/N M-1508 N2134ZAvex Holdings Heli Inc · Lewes, DEBuilt 1963 · S/N 18051234 N21351Midwest Flying Service LLC · Wilmington, DEBuilt 1974 · S/N 17263934 N21358Paroulek Joseph F · Milton, DEBuilt 1972 · S/N 18261585 N2135BMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7916110 N2135DN2135d LLC · Eustis, FLBuilt 2007 · S/N 18281899 N2135FMark Alan Bennett · Trinidad, COS/N 28-7990188 N2135KJet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9556 N2135SEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 172S9558 N2135TPeter Prince Aviation Center LLC · Milton, FLBuilt 1971 · S/N 28R-7135139 N2135WLeary Kevin · Midland, TXBuilt 1974 · S/N D-9648

Back to AD 2007-04-19 R1