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.

N127DMAircraft Leasing LLC · Peoria, ILBuilt 2017 · S/N 30023 N127DRKlamecki Alan P · Phoenix, AZBuilt 2001 · S/N 40028 N127EYoung John C · Olathe, KSBuilt 2001 · S/N 2146 N127EMKrein Chris · Bismarck, NDS/N 121707 N127EPAnnonsen Johnny · Dix Hills, NYBuilt 1985 · S/N 172-76481 N127ETThomas Eric C · Boise, IDBuilt 1982 · S/N 18268234 N127FCalifornia In Nice Inc · San Jose, CABuilt 1965 · S/N TC-869 N127FRYoon Paul · Saint David, AZS/N 17275292 N127HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2003 · S/N 172S9532 N127HHSoaring Fun Inc · Dover, DEBuilt 2017 · S/N 056/US N127JNNewman Jimmie L · Davenport, FLBuilt 2007 · S/N 24735 N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210 N127KJSky Flowers Holding Group LLC · Sunrise, FLS/N 10248 N127KWElizabeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9827 N127LFFisher Nicholis W · Springfield, LAS/N 27 N127MAVtflyboy LLC · Richmond, VTBuilt 2000 · S/N 30-0058 N127MBBerger Max · Daytona Beach, FLBuilt 1976 · S/N 310R0654 N127MDCosbie Lee R · Tuscumbia, ALBuilt 1963 · S/N 28-1503 N127PMinard Robert Myron Jr Trustee · Laveen, AZBuilt 1997 · S/N 24672 N127PSParsa Aviation LLC · Boca Raton, FLS/N 6010 N127RBushby Harvey M Jr · Minonka, ILBuilt 1995 · S/N M-II-1110 N127RLSkylane Of Ohio LLC · London, OHS/N 18262910 N127RWWindmiller David · Melville, NYBuilt 1976 · S/N TC-1958 N127SAVintage Tailwheel LLC · Wilmington, DEBuilt 2006 · S/N 1026-2006 N127SHWaverly R22 LLC · Oklahoma City, OKBuilt 2007 · S/N 4116 N127SKVoyager Exploration Inc · Marblehead, OHBuilt 2002 · S/N 0226 N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256 N127TGEberle Brian J · Newnan, GABuilt 2005 · S/N 21321 N127TJRegistration Pending · Bowersville, GARegistration pendingBuilt 1978 · S/N 18266629 N127TZMeng-Hannan Construction Inc · Portland, ORBuilt 2000 · S/N 2108 N127VATelkamp Gary O · Rapid City, SDBuilt 2003 · S/N 90127 N127VCSmith Von T · Chelan, WABuilt 1967 · S/N 18258041 N127VGEvans James F · Columbus, GABuilt 1978 · S/N 32R-7885274 N127WMMagnum Consulting Group Inc · Scottsdale, AZBuilt 1993 · S/N 1369 N127XKilgore Sky LLC · Parker, AZBuilt 2004 · S/N 40.438 N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271 N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275 N1280GSky Aviation And Consulting · Panorama City, CABuilt 1976 · S/N 310R0692 N1280KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13064 N1280TCertified Equipment Inspections LLC · Washington, PABuilt 1972 · S/N 28R-7235253 N1280VLindquist Lucy M · Hampshire, ILBuilt 1959 · S/N 34 N1280XErlandson Michael D · Salt Lake City, UTS/N 153 N12819Stewart Todd L · Mooresville, NCS/N 17262288 N1281KKirkwood Billie R · El Paso, TXBuilt 2011 · S/N 24143 N1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2006 · S/N 172S10333 N1281SChief Cornerstone LLC · Billings, MTBuilt 1976 · S/N 18264849 N12820US Aviation Group LLC · Denton, TXBuilt 1973 · S/N 17262289 N12821Hayslett Norman L · Roscoe, MOBuilt 1973 · S/N 17262290 N12822Courtney Aviation LLC · Columbia, CABuilt 1973 · S/N 17262291 N12828Fulwiler Air LLC · Green Bay, WIBuilt 1961 · S/N 3023

Back to AD 2007-04-19 R1