Skip to content

Registered aircraft · 20,681

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.

N128SHCalifornia In Nice Inc DBA · San Jose, CABuilt 2020 · S/N 172S12457 N12901American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262356 N12902Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1973 · S/N 17262357 N12908M & R Management Consulting Inc · Fort Meade, FLNon-citizen corporation, flight hours not reportedS/N 17262362 N12916Jacobs Airways Inc · Wilson, WIBuilt 1973 · S/N 17262369 N12917Dewhurst Donna A · Anchorage, AKBuilt 1973 · S/N 17262370 N12918Ashland/Boyd County Regional Airport Authority · Worthington, KYBuilt 1973 · S/N 17262371 N12919Gibson Aviation Services LLC · Menomonie, WIBuilt 1973 · S/N 17262372 N1291FRegistered aircraftBuilt 1979 · S/N 17272986 N12923Roberts Cody A · Lueders, TXBuilt 1973 · S/N 17262375 N12926Norton Boe L · Carlsbad, NMBuilt 1973 · S/N 17262378 N1292UFlynn James M · Plain City, OHBuilt 1976 · S/N 17266986 N12931Walden David C · Mesa, AZBuilt 1973 · S/N 17262382 N12933Van Anda Aviation LLC · Apopka, FLBuilt 1973 · S/N 17262384 N12935Ray Aviation LLC · Burkett, TXBuilt 1973 · S/N 17262386 N12936Quinlan Patrick J · Cooper City, FLBuilt 1973 · S/N 17262387 N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987 N12940Buffoon Flying Club · Mansfield, OHBuilt 1973 · S/N 17262388 N12943Titsworth R G · Seekonk, MABuilt 1973 · S/N 17262415 N12947Alltek Lebelle Ltd · Wilmington, DEBuilt 1973 · S/N 17262393 N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988 N12951Huestis Peggy J · Havre, MTS/N 17262397 N12952Wesselhoff Rick · Sedona, AZBuilt 1973 · S/N 17262398 N12953Witmer Travis R · Odenton, MDBuilt 1973 · S/N 17262399 N12955American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262400 N1295UWolff Timothy W Trustee · Monroe, WIBuilt 1976 · S/N 17266989 N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405 N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413 N1296UKirk Claire Y · Huntington Beach, CABuilt 1976 · S/N 17266990 N12973Mor Aviation LLC · Gaithersburg, MDBuilt 1973 · S/N 17262418 N12974Forest Ken W · Wales, NDBuilt 1972 · S/N 17262419 N12976Wanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1973 · S/N 17262421 N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990 N12983Haman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 17262427 N12985Alamakee Flyers · Waukon, IABuilt 1973 · S/N 17262429 N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432 N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437 N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993 N129AHN388vr LLC · Olalla, WABuilt 1963 · S/N 17251051 N129FRWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275338 N129HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9667 N129KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12825 N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118 N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503 N129SWRoyal Air LLC · Sarasota, FLBuilt 2018 · S/N 172S12210 N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741 N129WSNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S10012 N12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570 N12HZBaldauf Ryan L · Spencerville, OHBuilt 1976 · S/N 17266707 N12JMMroz Kaitlin J · Rhome, TXBuilt 1961 · S/N 17248841

Back to AD 90-06-03 R1