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.

N733SBWalker Andrew · Knoxville, TNBuilt 1977 · S/N 17268504 N733SFBurr Ralph C · Smyrna, GABuilt 1977 · S/N 17268507 N733SHChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12735 N733SKRcs Services LLC · California, MDBuilt 1977 · S/N 17268511 N733SLHardin John M · Terrell, TXBuilt 1977 · S/N 17268512 N733SMBoatright Arthur · Live Oak, FLS/N 17268513 N733SURosas Milton A · Kingsburg, CABuilt 1977 · S/N 17268519 N733SVBeard Mark S · Decker, INBuilt 1977 · S/N 17268520 N733SXTrimble Richard L · Forest City, IABuilt 1977 · S/N 17268522 N733SYDoutt Gerald G · Kalamazoo, MIBuilt 1977 · S/N 17268523 N733TCFlores Omar J · New Braunfels, TXBuilt 1977 · S/N 17268527 N733TDFrantzen Elizabeth · Davie, FLBuilt 1976 · S/N 17267136 N733TERedtail Partners LLC · Moab, UTBuilt 1977 · S/N 17268529 N733TJFenton Earl · Puyallup, WABuilt 1977 · S/N 17268533 N733TKCardiff Aviation Inc · Cardiff By The Sea, CABuilt 1977 · S/N 17268534 N733TLRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268535 N733TPR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 17268538 N733TQCarmel Aviation Inc · Boise, IDBuilt 1977 · S/N 17268539 N733TRWenatchee Sport Flyers · Wenatchee, WABuilt 1977 · S/N 17268540 N733TSCox Eileen Xiomara · Davie, FLBuilt 1977 · S/N 17268541 N733TTTeens In Flight Inc · Palm Coast, FLBuilt 1977 · S/N 17268542 N733TUChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12734 N733TVTempleton Bros Construction LLC · Livingston, TXBuilt 1977 · S/N 17268544 N733TXKelley Aircraft LLC · Weyers Cave, VABuilt 1977 · S/N 17268545 N733UAMergen John F · Baltimore, MDBuilt 1977 · S/N 17268548 N733UBKale Larry · Rogers, OHBuilt 1977 · S/N 17268549 N733UCSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 17268550 N733UDSpinks Flight Center Inc · Burleson, TXBuilt 1977 · S/N 17268551 N733UEWings Over Texas Holdings LLC · Denton, TXS/N 17268552 N733UFReid Dennis · Vinemont, ALBuilt 1977 · S/N 17268553 N733UGHoffman Thomas A Trustee · Emmett, KSBuilt 1977 · S/N 17268554 N733UJEngelhard Edward L · Hatfield, PABuilt 1977 · S/N 17268556 N733UNRugh Gene A · Wright City, MOS/N 17268560 N733UTOmartian Robert A · Simsbury, CTBuilt 1977 · S/N 17268565 N733VADrane Kenneth · Natchez, MSBuilt 1977 · S/N 17268572 N733VFGillen Scott E · San Diego, CABuilt 1977 · S/N 17268577 N733VGFrevert Darwin C · Highland Village, TXBuilt 1977 · S/N 17268578 N733VHAerospace Testing Engineering & Certification Inc · Seattle, WABuilt 1977 · S/N 17268579 N733VJLura Aaron P · Carrington, NDBuilt 1977 · S/N 17268580 N733VLYuma Ag Service Inc · Yuma, COBuilt 1977 · S/N 17268582 N733VRLegends Air Center LLC · Bentonville, ARBuilt 1977 · S/N 17268587 N733VSClemson Flying Club Inc · Seneca, SCBuilt 1977 · S/N 17268588 N733WCDrouin Roger R · Naples, FLBuilt 1977 · S/N 17268598 N733WEAirwaves Nsb LLC · New Smyrna Beach, FLBuilt 1977 · S/N 17268600 N733WGMiloud Chad · Fort Worth, TXBuilt 1977 · S/N 17268602 N733WHFritts Paul D · Southworth, WABuilt 1977 · S/N 17268603 N733WLShadduck James N · Annandale, MNS/N 17268606 N733WMNakamura Hajime Trustee · Long Beach, CABuilt 1977 · S/N 17268607 N733WSAirgo Inc · Centralia, ILBuilt 1977 · S/N 17268612 N733WTAnderson Aviation Services Inc · Carlsbad, CABuilt 1977 · S/N 17268613

Back to AD 90-06-03 R1