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.

N207TFPhotos Unlimited Inc · Rancho Cordova, CABuilt 1978 · S/N 20700492 N207TJBoos Timothy J · Fort Atkinson, WIBuilt 2007 · S/N 71909 N207VRB&C Properties LLC · Bristol, WIS/N 32-58 N207VWVanderwel Mark E · Monroe, WABuilt 1975 · S/N 20700311 N207WWalters William L · Boise, IDBuilt 1963 · S/N 18254647 N207WTHenson Alan · Houston, TXBuilt 2000 · S/N E-3308 N207XBane Russell · Palm Beach Gardens, FLBuilt 2005 · S/N 1207 N207YHGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700637 N207ZMInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N TH1677 N20801Loveland Christopher K · Meridian, IDBuilt 1973 · S/N 18261216 N20803Goad Jimmy L · Bradford, ARBuilt 1972 · S/N 18261217 N20804Ceddia Stephen J · Framingham, MABuilt 1974 · S/N 17263841 N20805Welzenbach Craig L · Fair Oaks Ranch, TXBuilt 1972 · S/N 18261219 N20806Young Todd Frederick · Pensacola, FLBuilt 1972 · S/N 18261220 N20807Dyess William C · Franklin, TNFirst renewal noticeBuilt 2005 · S/N 25772 N2080EBean James P · Tulsa, OKBuilt 1978 · S/N 17271147 N2080JWoelfel Tim A · Madisonville, TXBuilt 1978 · S/N T18803370T N2080LSparks Halli · Burdett, NYBuilt 1976 · S/N D-9902 N2080RTigert Tommy Ray · Ovilla, TXBuilt 1964 · S/N 18255280 N2080SRobinson Earl J · Cotuit, MABuilt 1966 · S/N D-8357 N2080VMcguire Rental Properties LLC · Prescott, ARBuilt 1979 · S/N 28-7916322 N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843 N20818N20818 LLC · Wilmington, DES/N 172S12579 N2081CTrident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7916128 N2081SPlane Nonsense Inc · Middletown, DEBuilt 2005 · S/N 172S10023 N2081TBaker Holdings LLC · Bedford, PAS/N 28R-7135025 N20820Maugeri Thomas V · Frankfort, NYBuilt 1972 · S/N 18261232 N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848 N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849 N20826Lc Aviation LLC · Mocksville, NCBuilt 2004 · S/N 0182 N20828Merrow R Loring · Beverly, MABuilt 1972 · S/N 18261238 N2082GKennedy Daniel M · Boise, IDBuilt 1958 · S/N 51382 N2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372T N2082WRegistered aircraftBuilt 1965 · S/N D-8008 N20830Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12580 N20831Olg Air LLC · Miami Gardens, FLS/N 18261239 N20832Wallace Fred · Ada, OKBuilt 1972 · S/N 18261240 N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850 N20836Morar Radu · Sutton, MABuilt 1972 · S/N 18261243 N20837Mjm Enterprise Holdings LLC · Drexel, MOBuilt 1974 · S/N 17263851 N20838Madden John D · Bellenue, WABuilt 1972 · S/N 18261245 N2083DSale Reported · Crystal, MNSale reportedBuilt 1978 · S/N 44-7995126 N2083FDetroit Public Schools Community District · Detroit, MIS/N 17280671 N2083LHorizon Chaser LLC · Woodway, TXS/N D-9904 N2083RSchutze Eric D Trustee · Ojai, CABuilt 1964 · S/N 18255283 N2083SDave Schmauderer · Woodland, CAS/N 21061049 N2083WKindig Eric J · Sidney, OHBuilt 1965 · S/N CD-990 N20841Fox Creek Aviation LLC · Jackson, WYBuilt 1972 · S/N 18261248 N20842Warner Kenneth G · Granbury, TXBuilt 1972 · S/N 18261249 N20843St Louis Flying Club Inc · Ellisville, MOBuilt 1974 · S/N 17263853

Back to AD 2007-04-19 R1