Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N15944Habit Samuel P · Kokomo, INBuilt 1973 · S/N 28-7305193 N15945Newton Flying Club Inc · Collinsville, MSBuilt 1972 · S/N 28-7305194 N15946Leading Edge Inc · Cottonwood Heights, UTBuilt 1973 · S/N 28-7305195 N1594CFlyrs Field · Anchorage, AKBuilt 1953 · S/N 30294 N1594LIntermill Alice R · Volga, SDBuilt 1976 · S/N E-833 N1594UFarmer Michael E · Greer, SCBuilt 1976 · S/N 17267176 N1594WFinnigan Jeffry A · Hoodsport, WABuilt 1972 · S/N CD-1290 N1594ZWondra Wayne L · Friendswood, TXBuilt 1961 · S/N D-6886 N15955Air Wings Enterprise LLC · Roca, NEBuilt 1973 · S/N 28-7325210 N15956Hanson Mark E · Griffin, GABuilt 1973 · S/N 28-7305196 N15957Jones John E Jr · Metter, GABuilt 1973 · S/N 28-7305197 N1595FVertical Horizon Aviation LLC · Sandown, NHBuilt 1966 · S/N 185-0977 N1595LClemens Jerry W · Parsons, KSBuilt 1976 · S/N D-9869 N1595RImpulsion Unlimited Inc · Huddleston, VABuilt 1975 · S/N AA5B-0095 N1595UJoiner Aviation LLC · Vinemont, ALBuilt 1973 · S/N U20602269 N1595WHope John W · Greeneville, TNFirst renewal noticeS/N TC-1448 N15961Kings Wings · Jupiter, FLBuilt 1973 · S/N 32-7300022 N15962Romero Jason Nathanial · Broken Arrow, OKS/N 28-7325213 N15966Acosta Aaron · El Paso, TXBuilt 1973 · S/N 28-7325214 N15968Culberson Donald J · Orange Park, FLBuilt 1973 · S/N 28-7305200 N1596CFennell Kenneth J · Palmer, AKBuilt 1953 · S/N 30296 N1596DSchneider Carl S · Tulsa, OKBuilt 1972 · S/N CD-1297 N1596ETeam 172-03 LLC · Warsaw, INS/N 17271060 N1596GN1596g Inc · Peachtree City, GABuilt 1974 · S/N 340-0507 N1596JWard Lawrence G · Mckenzie, ALBuilt 1941 · S/N 28-24007 N1596MKret Geoffrey W · Godley, TXBuilt 1975 · S/N 18264386 N1596RTc Aviation Ltd · Fairbanks, AKBuilt 1975 · S/N AA5B-0096 N1596TPlane Crazy Inc · Page, NDBuilt 1973 · S/N 4140376 N1596ZBarnett Paul S · Brookhaven, MSBuilt 1961 · S/N D-6887 N15975Bourgeois David · Westminster, MABuilt 1973 · S/N 28-7305226 N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203 N15979Tron Aviation LLC · Newburgh, INBuilt 1973 · S/N 28-7310079 N1597BRehman Furqan · Germantown, MDBuilt 1997 · S/N 2843104 N1597JLs Aviation LLC · Searcy, ARS/N 28-24008 N1597LTougas John D · Huntingtown, MDS/N CE-638 N1597MDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 18264387 N1597SJones William F · Seneca, SCBuilt 1962 · S/N CD-540 N1597WSmith William J · Wichita Falls, TXBuilt 1972 · S/N D-9359 N15984Hewitt Jeremy K · West Jordan, UTBuilt 1973 · S/N 28-7325218 N1598BTimerider Technologies Inc · Bishop, CABuilt 1982 · S/N 18268108 N1598HCarey Philip J Trustee · Wasilla, AKBuilt 1977 · S/N 18503314 N1598JHassard Maitland · Goodyear, AZBuilt 1967 · S/N 28-24009 N1598MZigler James B · Big Lake, MNBuilt 1975 · S/N 18264388 N1598RJam Cat LLC · Orlando, FLBuilt 1975 · S/N AA5B-0098 N1598SDougherty William G · Hacksneck, VABuilt 1962 · S/N D-7008 N1598TRegistered aircraftBuilt 1981 · S/N EA-263 N1598WCanvasback Investments LLC · Kerrville, TXBuilt 1972 · S/N D-9356 N1598ZMitchell Lester L · Okmulgee, OKBuilt 1961 · S/N D-6889 N15994Self Thomas C · Madisonville, TNS/N 28-7325222 N15997Stockman Greg · Allenton, MIBuilt 1973 · S/N 28-7305210

Back to AD 2007-04-19 R1