Skip to content

Registered aircraft · 20,687

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.

N7489AAllianna LLC · Fayetteville, ARBuilt 1956 · S/N 29589 N7489GCloud Fleet Aviation LLC · Fort Lauderdale, FLBuilt 1970 · S/N 17259189 N748CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11570 N748MKAero-Tech Services Inc · Lititz, PABuilt 2022 · S/N 172S12780 N748SPBg-Ip LLC · Saratoga, CABuilt 2000 · S/N 172S8682 N7490XDawson Ejay J · Eveleth, MNBuilt 1960 · S/N 17247990 N7491AMckee Paul R · Astoria, ORBuilt 1957 · S/N 29591 N7491GAccess Air Service Inc · Mercedita, PRBuilt 1970 · S/N 17259191 N7492TSale Reported · Newport, ORSale reportedS/N 47092 N7493GHaugo Robert P · Scobey, MTBuilt 1970 · S/N 17259193 N7493TLee Cody C · Denton, MTS/N 47093 N7495XIsch Philip D · Geneva, INBuilt 1960 · S/N 17247995 N7496AMcreynolds Sean D · Visalia, CABuilt 1956 · S/N 29596 N7496XAbove All Aviation Inc · Santa Barbara, CABuilt 1960 · S/N 17247996 N7497AJohnson Kurt W · Jordan, MNBuilt 1956 · S/N 29597 N7497TLeffler Greg L · Zion Crossroads, VABuilt 1959 · S/N 47097 N7497XTrinciante Fernando S · Thief River Falls, MNBuilt 1960 · S/N 17247997 N7498ATorrey Robert S · Anchorage, AKBuilt 1957 · S/N 29598 N7498TLala Princy · Deltona, FLBuilt 1959 · S/N 47098 N7499ADurousseau Joseph Harry Trustee · Sparks, NVBuilt 1957 · S/N 29599 N7499CHillsboro Flying Club · Hillsboro, ORBuilt 1981 · S/N 17274992 N7499TWright Donald E · Greensboro, NCBuilt 1959 · S/N 47099 N7499XVintage Aircraft Ltd · Hortonville, WIBuilt 1960 · S/N 17247999 N74CPersonal Aviation Inc · Poway, CABuilt 1978 · S/N 17270368 N74DMT C Rian Association LLC · Grove, OKBuilt 1973 · S/N 17262699 N74DWBas Part Sales LLC · Greeley, COBuilt 2001 · S/N 172S8735 N74ERSimplifly LLC · Mesa, AZBuilt 1977 · S/N 17269502 N74FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12937 N74JPGulf Coast Helicopters Inc · Pearland, TXBuilt 1974 · S/N 17263356 N74PESkycrafters Incorporated · Johnson City, TNBuilt 1973 · S/N 17262191 N7500TJacks Jerry W · Dalton, GABuilt 1960 · S/N 47100 N75013Frank Technologies Inc · Venice, CAS/N 17272705 N7502TDavis Chip · Apex, NCBuilt 1959 · S/N 47102 N7502XSnyder Mitchell R · Collierville, TNBuilt 1960 · S/N 17248002 N7503THutchison Greg A · Moses Lake, WABuilt 1959 · S/N 47103 N7503XLamb Barry · Moran, KSBuilt 1960 · S/N 17248003 N7504XMilnor Aviation Inc · Milnor, NDBuilt 1960 · S/N 17248004 N7505XCrumpacker John E · Timberville, VABuilt 1960 · S/N 17248005 N7506TLeblond Robert F · Wardsboro, VTBuilt 1959 · S/N 47106 N7506XRenquist John H · Valley Center, CABuilt 1960 · S/N 17248006 N7508TJasmer Steven M · Randle, WABuilt 1959 · S/N 47108 N7508XBain Sterling C Jr · Alexandria, LABuilt 1960 · S/N 17248008 N7509TMickelson Jason R · Shelton, WABuilt 1959 · S/N 47109 N7509XRussell Adam · Easton, MEBuilt 1960 · S/N 17248009 N750CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12533 N750YTwo Bar Aviation Inc · Lincoln, NES/N 17263139 N7510XSeifert Ross W · Pelican Rapids, MNBuilt 1960 · S/N 17248010 N7511TDonohue Jack L · Imperial, CAS/N 47111 N7512TCaldwell S F Bud · Paradise, CABuilt 1959 · S/N 47112 N7513XN7513x LLC · Cottonwood, CABuilt 1960 · S/N 17248013

Back to AD 90-06-03 R1