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.

N128VUTiger 2 Flying Club LLC · Geneseo, ILBuilt 1991 · S/N 10067 N128WMOac Aviation LLC · Asheville, NCBuilt 1997 · S/N E3115 N128WSSkyway Air Taxi LLC · Manassas, VABuilt 2001 · S/N TH-1982 N128YGorge Flight LLC · White Salmon, WABuilt 2016 · S/N 1128 N12901American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262356 N12902Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1973 · S/N 17262357 N12908M & R Management Consulting Inc · Fort Meade, FLNon-citizen corporation, flight hours not reportedS/N 17262362 N1290CPepper & Acorn LLC · Henderson, NVBuilt 2003 · S/N 0512 N1290FKilm LLC · Wilmington, NCBuilt 2007 · S/N 18282045 N1290JKrister Robert A · Kent, OHBuilt 1975 · S/N 290 N1290KN1290k LLC · Dover, DEBuilt 1965 · S/N 18256650 N1290MGardner Michael John · Ashland, ILBuilt 1975 · S/N 18264275 N1290RJones William Frank · Brea, CAFirst renewal noticeBuilt 1966 · S/N 4316 N12916Jacobs Airways Inc · Wilson, WIBuilt 1973 · S/N 17262369 N12917Dewhurst Donna A · Anchorage, AKBuilt 1973 · S/N 17262370 N12918Ashland/Boyd County Regional Airport Authority · Worthington, KYBuilt 1973 · S/N 17262371 N12919Gibson Aviation Services LLC · Menomonie, WIBuilt 1973 · S/N 17262372 N1291CVand Flyve Klub · Newfolden, MNS/N 18-2502 N1291FRegistered aircraftBuilt 1979 · S/N 17272986 N1291MCon Air Aviation LLC · Westerville, OHBuilt 1975 · S/N 18264276 N1291PPowers Elbie L · Roseboro, NCBuilt 1965 · S/N 18256573 N1291SAvidyne Corp · Melbourne, FLBuilt 1976 · S/N 18264858 N12923Roberts Cody A · Lueders, TXBuilt 1973 · S/N 17262375 N12926Norton Boe L · Carlsbad, NMBuilt 1973 · S/N 17262378 N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696 N1292FRustair Inc · Anchorage, AKBuilt 1975 · S/N 18502668 N1292GBahig Saliba · Scottsdale, AZBuilt 1974 · S/N 310Q1141 N1292JSoutheast Michigan Aircraft Sales Inc · Blissfield, MIBuilt 1975 · S/N 292 N1292MCool Change Rentals LLC · Beaufort, NCBuilt 1975 · S/N 18264277 N1292PEm Turbines Corp · Fort Lauderdale, FLS/N 23-327 N1292RHudson Mitchell C · Erie, COBuilt 1966 · S/N 4324 N1292UFlynn James M · Plain City, OHBuilt 1976 · S/N 17266986 N1292XBurns Barry D · Amarillo, TXBuilt 1963 · S/N 165 N12931Walden David C · Mesa, AZBuilt 1973 · S/N 17262382 N12933Van Anda Aviation LLC · Apopka, FLBuilt 1973 · S/N 17262384 N12935Ray Aviation LLC · Burkett, TXBuilt 1973 · S/N 17262386 N12936Quinlan Patrick J · Cooper City, FLBuilt 1973 · S/N 17262387 N1293CTexas Blue Skies Aviation LLC · Canyon Lake, TXBuilt 2003 · S/N 0565 N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987 N1293SMeyer Raymond · Belding, MIBuilt 1976 · S/N 18264860 N1293TN1293t LLC · Wilmington, DES/N 34-7250283 N12940Buffoon Flying Club · Mansfield, OHBuilt 1973 · S/N 17262388 N12943Titsworth R G · Seekonk, MABuilt 1973 · S/N 17262415 N12947Alltek Lebelle Ltd · Wilmington, DEBuilt 1973 · S/N 17262393 N1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeBuilt 1977 · S/N 17702698 N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988 N1294SSheehan Dennis M · Stoughton, WIBuilt 1976 · S/N 18264861 N1294XMcglynn Brian · Friday Harbor, WABuilt 1963 · S/N 167 N12951Huestis Peggy J · Havre, MTS/N 17262397 N12952Wesselhoff Rick · Sedona, AZBuilt 1973 · S/N 17262398

Back to AD 2007-04-19 R1