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.

N15664Bergantino Julio L Jr · Tucson, AZBuilt 1972 · S/N 28-7305113 N15665Burns Dana W · Pataskala, OHS/N 28R-7335079 N15666Miller Michelle · Las Vegas, NVBuilt 1972 · S/N 28-7310065 N1566FSelhay Michael J · Anchorage, AKBuilt 1965 · S/N 185-0943 N1566GDuntz David W · Beavercreek, OHBuilt 1989 · S/N CE-1346 N1566JGjestson Derek · Brooklyn Park, MNS/N 28-23971 N1566KShaw David C · Santa Barbara, CABuilt 1989 · S/N TH-1549 N1566LRedden Timothy Ray · Citrus Heights, CABuilt 1976 · S/N D-9862 N1566PBeech Powers LLC · Henderson, NVBuilt 1988 · S/N CE-1294 N1566URegistered aircraftBuilt 1994 · S/N E-2872 N1566WPsl Aviation Inc · Atlanta, GABuilt 1994 · S/N TH-1713 N15671On Final Aviation LLC · Brookland, ARS/N 28-7325131 N15675Airfleet Solutions LLC · Newark, DEBuilt 1972 · S/N 28-7325134 N15677Magneto Flyers LLC · Alexandria, OHBuilt 1972 · S/N 28-7305114 N15678Pg Farms Inc · Shelton, NEBuilt 1972 · S/N 28-7305116 N1567AKarsten Steven R · San Juan Capo, CABuilt 1969 · S/N TC-1270 N1567JBerry'S Air Freight Inc · West Columbia, SCBuilt 1967 · S/N 28-23972 N1567MPlumbo John T · Port Saint Lucie, FLBuilt 1989 · S/N CE-1407 N1567NAuburn Simflight LLC · Auburn, ALBuilt 1989 · S/N TH-1567 N1567PMy Family Holdings LLC · Greenwood, SCBuilt 1988 · S/N CE-1296 N1567SWegener Properties LLC Series Bonanza · Aurora, ILBuilt 1962 · S/N D-6993 N1567VRasmussen Bryan K · Wilsonville, ORS/N 17263668 N15682Bold Pipe Dream LLC · Los Angeles, CABuilt 1972 · S/N 28-7325135 N15684Carr Sean Michael-Noel · Prescott, AZBuilt 1972 · S/N 28R-7335081 N15688Moses & Associates Inc · Gainesville, FLBuilt 1988 · S/N TH-1542 N1568RRobinson Leonard C · Boca Raton, FLBuilt 1975 · S/N AA5B-0068 N1568ZKeenan Michael Richard Sr · Albuquerque, NMBuilt 1961 · S/N D-6870 N15694Registered aircraftBuilt 1972 · S/N 28-7305119 N15695Baldwin Lydia H · Fort Collins, COBuilt 1972 · S/N 28-7305120 N15696Truair LLC · Chaska, MNBuilt 1937 · S/N 1 N1569LRegistered aircraftBuilt 1976 · S/N TC-1945 N1569PFlying Bull Aviation LLC · Santee, CABuilt 1988 · S/N CE-1300 N1569USchoolcraft Carl L · West Harrison, INBuilt 1973 · S/N U20602262 N1569XStroud Jerry L · Hope, ARS/N 28R-7535331 N156ASkymook Aviation LLC · Beaver Falls, PABuilt 1977 · S/N TK-56 N156AADardis Aviation LLC · Alpine, WYBuilt 2007 · S/N 2390 N156AEHolt Cory J · Santa Ynez, CABuilt 1962 · S/N 18254549 N156ASWallwork Robert R III · Wauna, WABuilt 1976 · S/N MB-805 N156BDWoods Donald E · Great Falls, MTBuilt 1987 · S/N 156 N156CMOwens Christopher · New Auburn, WIBuilt 2012 · S/N 20361 N156CPPeeples Cary B · North Olmsted, OHBuilt 2002 · S/N CP2002-1 N156DCEaton Billy J · Bridgeport, TXBuilt 1961 · S/N 24-2751 N156DMDeleonrdis Donato · Paulden, AZBuilt 2004 · S/N 18 N156DSFanoe Nicholas J · Salinas, CABuilt 2000 · S/N 23064C N156EDemmers Jesse T · Brandon, SDBuilt 2015 · S/N 90605 N156EWSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1998 · S/N 2842028 N156HRCallahan Bryan J · Apalachicola, FLBuilt 2007 · S/N 156 KIT N156JBSully Air LLC · Atlanta, GABuilt 2001 · S/N 40019 N156JMTrechak Ashley L · Shafter, CABuilt 1956 · S/N 32360 N156KCWhitney Aviation LLC · Derry, NHBuilt 1978 · S/N 18503621

Back to AD 2007-04-19 R1