Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N199LPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 17264143 N199MCFly N199mc LLC · Nevada City, CABuilt 1977 · S/N 17268570 N199SPW Air LLC · Wheeling, ILBuilt 2003 · S/N 172S9467 N19HRJernigan Michael G · Toledo, ORBuilt 1966 · S/N 17255607 N19MVSky Path Aviation LLC · Sheridan, WYBuilt 2019 · S/N 172S12273 N19NJN19nj LLC · Manassas, VABuilt 1985 · S/N 17276343 N19WSHolcomb Nicholas A · Yakutat, AKS/N 29689 N1AXEdgerton Agency Inc · Galena, OHBuilt 1960 · S/N 47418 N1EHandschiegel Robert J · Hampshire, ILBuilt 1976 · S/N 17267046 N1JHHolden James E · Las Vegas, NVBuilt 1975 · S/N 17265723 N1KUUniversity Of Kansas Aerospace Engineering Dept · Lawrence, KSBuilt 1974 · S/N 17262270 N1QSUniversal Investment Group LLC Trustee · La Crescenta, CABuilt 1975 · S/N 17265177 N1TAJustine Lorraine F · Newark, DEBuilt 1972 · S/N 17260453 N1XSaitto Jeffrey M · Media, PABuilt 1965 · S/N 17252958 N20005Lmbi Inc · Sierra Vista, AZBuilt 1972 · S/N 17260923 N20009Moore Douglas R · Garfield, GABuilt 1972 · S/N 17260926 N2000CTextron Aviation Inc · Wichita, KSS/N 172S13601 N20012Hester Edward R · Bladenboro, NCS/N 17260929 N20014Wines Ira · Tuscarora, NVBuilt 1972 · S/N 17260930 N20015Airplanes And Attitude LLC · Mckinney, TXBuilt 1972 · S/N 17260931 N20018Aerofeather Aviation Inc · Suffolk, VAS/N 17260934 N20019Mccall Freddie W · Brewton, ALBuilt 1972 · S/N 17260935 N2001YShaffer Stephen M · East Springfield, PABuilt 1962 · S/N 17249501 N20025Golden Eagle 025 LLC · Cary, NCBuilt 1972 · S/N 17260941 N20026Leatherman Randal A · Fairplay, MDBuilt 1972 · S/N 17260942 N20029Kedrowski Daniel J · Ham Lake, MNBuilt 1972 · S/N 17260944 N20031Bulman Erik D · Kailua, HIBuilt 1972 · S/N 17260946 N20032Noone Robert T · Glencoe, ALBuilt 1972 · S/N 17260947 N20033Coddiwomple LLC · Newberg, ORBuilt 1972 · S/N 17260948 N20038Kimmel Tara L · Cloquet, MNBuilt 1972 · S/N 17260951 N20039Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1972 · S/N 17260952 N2003EHarman Dane P · Halifax, PABuilt 1978 · S/N 17271116 N20040Victor Francois · Carrollton, TXBuilt 1972 · S/N 17260953 N20041Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260954 N20045Massey Travel LLC · Ozark, MOBuilt 1972 · S/N 17260958 N20046Blue Panda LLC · Olive Branch, MSBuilt 1972 · S/N 17260959 N20047Flying Broke Acres LLC · Lexington, NEBuilt 1972 · S/N 17260960 N2004UEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13449 N20050Florida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 17260962 N20051Hayek Pierre N · Alta Loma, CABuilt 1972 · S/N 17260963 N20052Atkinson Brandon A · Pageland, SCBuilt 1972 · S/N 17260964 N20053Spanaflight LLC · Puyallup, WABuilt 1972 · S/N 17260965 N20055Chesley Laurence J · Valdez, AKBuilt 1972 · S/N 17260967 N20057Opiela Robert M · Hampton, NHBuilt 1972 · S/N 17260969 N20058Ballou Skies Aviation Inc · Bucyrus, OHBuilt 1972 · S/N 17260970 N20060Bakken George S · Terre Haute, INBuilt 1972 · S/N 17260972 N200617b Flying Club Inc · Sandpoint, IDBuilt 1972 · S/N 17260973 N20063Beery Milo A DBA · Clarinda, IABuilt 1972 · S/N 17260975 N20065Southern Aero LLC · Homestead, FLBuilt 1972 · S/N 17260977 N20067Epic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13448

Back to AD 90-06-03 R1