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.

N156LGAirsign Airships America LLC · Williston, FLBuilt 2000 · S/N 106 N156LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842198 N156LMLoup Technologies Inc · Longmont, COBuilt 1966 · S/N 30-1017 N156MRegistered aircraftBuilt 1979 · S/N 18053114 N156MAMedia Exp LLC · Portland, ORBuilt 1997 · S/N 001 N156MEArcher III LLC · Littleton, COBuilt 2000 · S/N 172S8435 N156MTSpeer James M Jr · Boonville, NCBuilt 1989 · S/N 0253 N156PSSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 40.492 N156RACase Bruce · Verona, WIBuilt 2007 · S/N 1429-2007 N156RMMarek Robert C · Cadott, WIBuilt 2001 · S/N 019 N156SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4159 N156UUtah State Univeristy · Logan, UTBuilt 2025 · S/N 40.1252 N156VBooher Daniel Ross · Humble, TXBuilt 1957 · S/N 50019 N156WMFixed Wing Holding Company Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496156 N156XN156x LLC · Fayetteville, GABuilt 1978 · S/N 32-7840156 N156XDBurgess Mark W · Greene, MES/N 17268718 N15701Miranowski Dean A · Goddard, KSBuilt 1972 · S/N 28-7325142 N15703Schubert Brothers Aviation Inc · Canandaigua, NYFirst renewal noticeBuilt 1972 · S/N 28-7305125 N15707Brennan Christopher S · Newark, DEBuilt 1972 · S/N 28-7310069 N15709Avioelectronica Inc · Sunrise, FLS/N 34-7350088 N1570CMottern Edward Thomas · Greenwood, SCBuilt 2003 · S/N 0569 N1570GTurner Michael D · Greenwood, SCBuilt 1989 · S/N E-2512 N1570NUp N Down Adventures LLC · Calera, OKBuilt 1994 · S/N TH-1715 N1570RHall Clarence W Jr · Fayetteville, ARS/N M-1368 N1570TAcr Holdings LLC · Marysville, OHBuilt 1989 · S/N CE-1365 N1570UReno70 LLC · Anchorage, AKBuilt 1970 · S/N 20700170 N1570VMcdermott John P Trustee · Redding, CABuilt 1974 · S/N 17263671 N1570ZSalvay Michael E · Long Beach, CABuilt 1961 · S/N D-6872 N15715Pilotronics LLC · Bay Village, OHBuilt 1972 · S/N 28-7325144 N15716Otero Jose L · Harker Heights, TXBuilt 1972 · S/N 28-7325145 N1571EMorgan Steven P · Roswell, GABuilt 1978 · S/N 17271049 N1571JAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1967 · S/N 28-23977 N1571UFavero Michael R · Sacramento, CABuilt 1973 · S/N U20602263 N1571VPeabody Jeffery L · Vinemont, ALBuilt 1974 · S/N 17263672 N1571WWest Elk Construction Ltd · Milliken, COBuilt 1972 · S/N D-9349 N15724Mcrae Roy Sean · Thorne Bay, AKBuilt 1972 · S/N 18052292 N15725Hassell Dan J · Ketchikan, AKBuilt 1991 · S/N S1565 N15726Aircraft Repair Center · Lake Worth, FLBuilt 1972 · S/N 28-7325147 N1572RBurke Kenneth L · Colleyville, TXBuilt 1975 · S/N AA5B-0072 N1572VWaldroup Anthony Wayne · Konawa, OKBuilt 1974 · S/N 17263673 N1572XRaleigh Flying Club LLC · Raleigh, NCBuilt 1975 · S/N 28-7515425 N15731Parsons Allen L · Marriottsville, MDBuilt 1972 · S/N 28-7305129 N15734Wayland Flyboys LLC · Wayland, IABuilt 1972 · S/N 28-7305131 N15735235 Aviation LLC · New Smyrna Beach, FLS/N 28-7310071 N15739Flymart Inc · Hastings, FLS/N 28-7305132 N1573FSmith David J · Duluth, MNBuilt 1965 · S/N 185-0949 N1573RGrand Scott LLC · Okemos, MIBuilt 1975 · S/N AA5B-0073 N1573SMckee Keith L · Fuquay Varina, NCBuilt 1962 · S/N CD-528 N15741Jps Flight School LLC · Salem, ORBuilt 1972 · S/N 28-7305134 N15744West Kentucky Flyers Corp · Murray, KYBuilt 1972 · S/N 28R-7335086

Back to AD 2007-04-19 R1