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.

N7207GCowden Flying Services Inc · Fort Worth, TXBuilt 1969 · S/N 17258907 N7207QMountain Peaks Aviation LLC · Clancy, MTBuilt 1972 · S/N 17260507 N7207TMrzena Matthew D · Wasilla, AKBuilt 1959 · S/N 46807 N7208GBurgess Keith · Arnoldsville, GABuilt 1969 · S/N 17258908 N7209GElite Planes LLC · Menifee, CABuilt 1969 · S/N 17258909 N7209QKimble Leon · Rocky Hill, CTBuilt 1972 · S/N 17260509 N7209TBouchez Lawrence T · Manhattan Beach, CABuilt 1959 · S/N 46809 N720CAAero Equities LLC · Oxnard, CABuilt 2026 · S/N 172S13528 N720CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11564 N720LULiberty University Inc · Lynchburg, VABuilt 2023 · S/N 172S13075 N7210GOgle Howard J · Moorpark, CAS/N 17258910 N7210QAthol Orange Aero Club Inc · Athol, MABuilt 1972 · S/N 17260510 N7211ATravis Michael B · Camano Island, WABuilt 1956 · S/N 29311 N7211THargrove Nicholas A · Lago Vista, TXBuilt 1959 · S/N 46811 N7212ABlane Steven C · Rockville, INBuilt 1956 · S/N 29312 N7212GMeister James A · Star Prairie, WIBuilt 1969 · S/N 17258912 N7212QLink Air Service LLC · Minong, WIBuilt 1972 · S/N 17260512 N7213QChain O Lakes Flying Club & Co Inc · Waupaca, WIBuilt 1972 · S/N 17260513 N7214TKennedy John M · San Leandro, CABuilt 1960 · S/N 46814 N7215QRhynette Airways LLC · Key Largo, FLBuilt 1972 · S/N 17260515 N7215TSmith Jon O · Leavenworth, WAFirst renewal noticeBuilt 1959 · S/N 46815 N7216GLincoln Skyways Inc · Lincoln, CABuilt 1969 · S/N 17258916 N7216QElias Close Deanna · Kenilworth, ILBuilt 1972 · S/N 17260516 N7216TRk Air LLC · Wilmington, DEBuilt 1959 · S/N 46816 N7217AMcguires Flying Service LLC · Obion, TNBuilt 1956 · S/N 29317 N7217GOne Niner Right LLC · Berkeley, CABuilt 1969 · S/N 17258917 N7217QRegistration Pending · Fond Du Lac, WIRegistration pendingS/N 17260517 N7217TDenney David W · Fowler, COS/N 46817 N7218AGurdak Paul J · Bristol, VTBuilt 1956 · S/N 29318 N7218TTwilley Reginald M · Mobile, ALFirst renewal noticeBuilt 1959 · S/N 46818 N7219TScott Gregory R · Kennesaw, GABuilt 1959 · S/N 46819 N721AAGammage Linda L · Delanco, NJBuilt 1968 · S/N 17257605 N721CTChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10140 N721EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13055 N721LULiberty University · Lynchburg, VABuilt 2010 · S/N 172S11056 N721MWelch James D · Holdenville, OKBuilt 1957 · S/N 29879 N721SACommonwealth Of Massachusetts · Bridgewater, MABuilt 1997 · S/N 17280239 N721THAtp Aircraft 7 LLC · Wilmington, DEBuilt 2017 · S/N 172S12011 N7220GStagg Travis M · Fairbanks, AKBuilt 1969 · S/N 17258920 N7221QSleeping Giant Flying Club · Helena, MTBuilt 1972 · S/N 17260521 N7221TDahle Neil E · Mason City, IABuilt 1959 · S/N 46821 N7222AChamberlain C Douglas · Bellefontaine, OHBuilt 1956 · S/N 29322 N7222QMohawk Flying Club Inc · Ada, MIBuilt 1972 · S/N 17260522 N7222TRegistration Pending · Lawndale, CARegistration pendingBuilt 1959 · S/N 46822 N7223ASather Evan · Hayward, CAS/N 29323 N7223QBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260523 N7223TRoberts Michael R · Plano, TXBuilt 1959 · S/N 46823 N7225AFouts Philip W · Caldwell, IDBuilt 1956 · S/N 29325 N7225GVance Wilbur H III · Hershey, PABuilt 1970 · S/N 17258925 N7225VConnecticut Aircraft Sales LLC · Manchester, CTBuilt 1977 · S/N 17270030

Back to AD 90-06-03 R1