Skip to content

Registered aircraft · 1,289

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:98-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-01-01') 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:98-01-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-01-01')
  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:98-01-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-01-01')
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.

N100LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280075 N101LULynn University Inc · Boca Raton, FLBuilt 1999 · S/N 17280709 N101VBRegistered aircraftBuilt 1999 · S/N 18280438 N102FVGruba Sheila M · Saint Joseph, MNBuilt 1998 · S/N 17280552 N102HWDhs Operations LLC · Wilmington, DEBuilt 2001 · S/N 17281058 N102MASquaw Creek Aviation LLC · Dover, DES/N 18280100 N102MUTraining Planes LLC · Tampa, FLBuilt 1997 · S/N 17280285 N1033AAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 17281238 N103FVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280553 N103LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280298 N103NCState Of North Carolina · Raleigh, NCBuilt 1999 · S/N 18280647 N103SVSun Valley Aviation Inc · Harlingen, TXBuilt 1998 · S/N 17280534 N104ABPeterson Kevin D · Peoria, AZBuilt 1998 · S/N 18280280 N104LULynn University Inc · Boca Raton, FLBuilt 1998 · S/N 17280625 N104PFLewis University · Romeoville, ILBuilt 1998 · S/N 17280313 N10632Skyblue Aviation Cr Inc · Merritt Island, FLBuilt 2007 · S/N 17281431 N106AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2001 · S/N 17281055 N107AFKummer Michael · Floyd'S Knobs, INBuilt 2001 · S/N 17281056 N107PFConant Dakotah · Ocala, FLBuilt 1998 · S/N 18280220 N108PFKeith Wilcox & Sons Inc · Rexburg, IDBuilt 1998 · S/N 18280092 N109LULynn University Inc · Boca Raton, FLBuilt 2001 · S/N 17280991 N109TJLanier Equipment Leasing LLC · Gainesville, GABuilt 2001 · S/N 17280985 N10AVMaak Holdings LLC · Missoula, MTBuilt 1999 · S/N 18280129 N11024Cao Wayne M · Dublin, CABuilt 2000 · S/N 17280913 N110LULynn University Inc · Boca Raton, FLBuilt 2006 · S/N 17281326 N112PFEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280400 N113PFPremier Flight Center LLC · Hartford, CTBuilt 1998 · S/N 17280401 N1157RSale Reported · Miami, FLSale reportedBuilt 1998 · S/N 17280627 N115KSKent State University · Stow, OHBuilt 1999 · S/N 17280819 N115PFHigh Tech Metals Inc · Harrisburg, PABuilt 1998 · S/N 18280224 N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820 N116VGBruns Phillip T · Shiro, TXBuilt 1998 · S/N 18280346 N116WBDunch David J Trustee · Poland, OHBuilt 1998 · S/N 18280170 N116ZXVranjes Peter · Johnstown, COBuilt 1997 · S/N 18280042 N117KSKent State University · Stow, OHBuilt 1999 · S/N 17280821 N117SDLong Joseph F · Carroll, OHS/N 18280926 N118ETL & W Leasing LLC · Smyrna, TNBuilt 1997 · S/N 17280019 N118FSTfs Air LLC · Loveland, COBuilt 2003 · S/N 17281198 N118KSKent State University · Stow, OHBuilt 1999 · S/N 17280822 N1190DCds Enterprise Group LLC · Ionia, MIBuilt 2000 · S/N 18280694 N119KSKent State University · Stow, OHBuilt 1999 · S/N 17280823 N120GRStarlight Flight Aerial Tours LLC · Coppell, TXBuilt 1999 · S/N 18280430 N121UCEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280420 N122DTFine Point Aviation LLC · Carrollton, GABuilt 2000 · S/N 18280908 N123ARRullan Alberto · Adjuntas, PRBuilt 1998 · S/N 18280232 N124EFGuerrer Daniel S · Redondo Beach, CABuilt 1998 · S/N 18280315 N1252EStedje Timothy M · Gruver, TXBuilt 1999 · S/N 18280580 N125LGWheat Travis W · Henderson, NVS/N 18280070 N125WWKapotes Nicholas Stephan · Pompton Plains, NJBuilt 1998 · S/N 18280348 N129SEBarrington Air Inc · Littleton, COBuilt 1998 · S/N 18280384

Back to AD 98-01-01