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.

N26FPTate Zachary W · Cypress, TXBuilt 1978 · S/N 17271318 N26LPAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13252 N26TFTop Flight Aviation Inc · Corona, CABuilt 1972 · S/N 17261318 N26ZWeber Mark S · Wildwood, MOBuilt 1969 · S/N 17258153 N2700LFly First LLC · West Memphis, ARBuilt 1967 · S/N 17255900 N2700UMinier Manuel · Kissimmee, FLS/N 17250300 N2701LRegistration Pending · Los Angeles, CARegistration pendingBuilt 1967 · S/N 17255901 N2702ULeatherwood Vaughn L · La Place, LAS/N 17250302 N2704LAgrifoglio Douglas · Reedley, CABuilt 1967 · S/N 17255904 N2706UHoelsch Shawn C · Livermore, CABuilt 1963 · S/N 17250306 N2707UHills Holding · Newark, DEBuilt 1963 · S/N 17250307 N2708LRafter Jm Enterprises LLC · Swink, OKBuilt 1967 · S/N 17255908 N2709LGuideair LLC · Eden Prairie, MNBuilt 1967 · S/N 17255909 N270AMCode 1 Flight Training LLC · Wills Point, TXBuilt 1973 · S/N 17262722 N270CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13089 N270JARegistered aircraftBuilt 2000 · S/N 172S8619 N270UOhio University · Albany, OHBuilt 2003 · S/N 172S9520 N2710UCape Aerial Tours DBA · Chatham, MABuilt 1963 · S/N 17250310 N2711RBoeing Employees Flying Association Inc · Renton, WABuilt 2001 · S/N 172S8864 N2713LFlemmer Richard W · Park City, MTBuilt 1967 · S/N 17255913 N2713UAeronetica LLC · Tulsa, OKS/N 17250313 N2715LGoebel Christian E · Luray, VABuilt 1967 · S/N 17255915 N2715UBelle Fourche Flight Center LLC · Belle Fourche, SDBuilt 1963 · S/N 17250315 N2717URasmussen Raleigh C · Seattle, WABuilt 1963 · S/N 17250317 N2718UBondurant Ross · Eugene, ORBuilt 1963 · S/N 17250318 N2719UVilches Armando L · Brentwood, TNBuilt 1963 · S/N 17250319 N271AMMonthy Christian · Van Nuys, CABuilt 1973 · S/N 17262510 N271CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13090 N271GTBroulik Robert L · Lisbon, IABuilt 1976 · S/N 17267114 N271REEigsti Rodney E Trustee · Friend, NEBuilt 1960 · S/N 47227 N271RMMartinson Ryan D · Nome, AKBuilt 1957 · S/N 36130 N2720EAmerican Patrols Inc · Midland, TXBuilt 1978 · S/N 17271305 N2720LBaalman Gary E · San Jose, CABuilt 1967 · S/N 17255920 N2722LSmolik Amanda · Northlake, TXBuilt 1967 · S/N 17255922 N2723EMarshals Technology LLC · Martinez, GABuilt 1978 · S/N 17271306 N2723LJkr7 LLC · The Dalles, ORBuilt 1967 · S/N 17255923 N2724UGarner Harry W · Le Roy, NYBuilt 1963 · S/N 17250324 N2725LFulenchek Raymond D · Sherman, TXS/N 17255925 N2726USampan Aviation LLC · Greenville, TXS/N 17250326 N2727URoy Justin C · Georgetown, OHBuilt 1963 · S/N 17250327 N2728LPotter Mark H · Santa Rosa, CABuilt 1967 · S/N 17255928 N2728UCatsakis Andrew W · Lovettsville, VABuilt 1963 · S/N 17250328 N2729UDenair Inc · Canandaigua, NYBuilt 1963 · S/N 17250329 N272DBBrock Dean R · Hawthorne, FLBuilt 1973 · S/N 17261821 N272DKKroutil David W · Hilmar, CABuilt 1978 · S/N 17271857 N272FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13454 N272HFHorizon Flight Center LLC · Chesapeake, VABuilt 2022 · S/N 172S12776 N272JAGold Coast Aviation LLC · Oxnard, CABuilt 1976 · S/N 17267439 N272LPAa-Aero Inc · Fairfield, NJBuilt 2002 · S/N 172S9272 N272MMTownair LLC · Sandy, UTBuilt 2006 · S/N 172S10105

Back to AD 90-06-03 R1