Skip to content

Registered aircraft · 3,193

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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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:77-13-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
  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:77-13-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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.

N55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 30-804 N55CYBonneville Aero Works LLC · Greenville, SCBuilt 1961 · S/N 24-2674 N55RDSchober David · Union Bridge, MDBuilt 1966 · S/N 30-1307 N5600PBfi Inspections LLC · Nevada City, CAS/N 24681 N5601PDevil Dusters Inc · Artesia, NMS/N 24-669 N5603PLitteken David T · Aviston, ILBuilt 1959 · S/N 24-671 N5611PWeyland Aviation Inc · Lewes, DEBuilt 1959 · S/N 24-679 N5612PClarity Aviation LLC · Boise, IDBuilt 1959 · S/N 24-680 N5614PShetty Balakrishna · Wesley Chapel, FLBuilt 1959 · S/N 24-682 N5616PKallenberger Ross A · Bakersfield, CABuilt 1959 · S/N 24-684 N5617PBuchheit Dirk · Lake Worth, FLBuilt 1959 · S/N 24-685 N5622PBaker Franklin E · Montgomery, ILBuilt 1959 · S/N 24-691 N5624PCobb Jeremiah B · Colorado Springs, COBuilt 1959 · S/N 24-693 N5628PMiller Space A · Simi Valley, CABuilt 1959 · S/N 24-698 N5629PVick Josh K · Brentwood, TNS/N 24-699 N5630PWick Eric J · Three Lakes, WIBuilt 1959 · S/N 24-700 N5631PNeal Brian C · Monrovia, CABuilt 1959 · S/N 24-701 N5634PWaters George A · Oklahoma City, OKBuilt 1959 · S/N 24-704 N5637PSellman Richard · Chadron, NEBuilt 1959 · S/N 24-707 N5643PRed Cardinal Aviation LLC · Chantilly, VABuilt 1959 · S/N 24-713 N5645PDeines E Jay · Wa Keeney, KSBuilt 1954 · S/N 24-715 N5651PSeremet Cristina L · Beaver Dam, WIBuilt 1959 · S/N 24-722 N5653PBeasley Charles R · Lumberton, NCBuilt 1959 · S/N 24-724 N5654PLiebrecht Dennis L DBA · Ocala, FLBuilt 1959 · S/N 24-725 N5656PTaylor National Transportation LLC · Palatine, ILBuilt 1959 · S/N 24-727 N566BSSand Farm Management Services LLC · Adel, IABuilt 1970 · S/N 39-56 N5670PBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 24-742 N5674PNeely Antwuan T · Savoy, ILBuilt 1959 · S/N 24-746 N5675PLandolt Gregg E · Moreno Valley, CAFirst renewal noticeBuilt 1959 · S/N 24-747 N5678PWhite John O · Camarillo, CABuilt 1959 · S/N 24-750 N5679PKuehnert Stefan · Clarkesville, GABuilt 1959 · S/N 24-751 N567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationBuilt 1970 · S/N 39-63 N5684PAce Drilling LLC · Johnson, KSBuilt 1959 · S/N 24-756 N5686PGray Gary L · Frederick, OKBuilt 1959 · S/N 24-758 N5691PCoady Michael · Taylorville, ILBuilt 1959 · S/N 24-763 N5693PBays Aviation LLC · Boerne, TXBuilt 1959 · S/N 24-766 N5699PHahn Curtis D · St George, UTBuilt 1959 · S/N 24-772 N56CCMichel David L · Pickens, SCBuilt 1959 · S/N 24-1297 N5700PEdmundson George · Burlington, WABuilt 1959 · S/N 24-773 N5702PChilds Group Inc · Altoona, IABuilt 1959 · S/N 24-775 N5705PN5705p Inc · Pompano Beach, FLBuilt 1959 · S/N 24-778 N5709PSaadjack LLC · Amelia Island, FLBuilt 1959 · S/N 24-783 N5712PGibson Kevin M · Denver City, TXBuilt 1959 · S/N 24-786 N5717PGraber Tim B · Santee, CABuilt 1959 · S/N 24-791 N5720PPatterman Emil S · Fort Worth, TXS/N 24-794 N5722PCrazy 8 Aviation LLC · Ridgecrest, CABuilt 1959 · S/N 24-796 N5725PJason Waddell Pllc · Oklahoma City, OKBuilt 1959 · S/N 24-799 N5728PElite Aviation LLC · Grants Pass, ORBuilt 1959 · S/N 24-802 N5729PSturt Michael H · Whitehouse, OHBuilt 1959 · S/N 24-803 N5733PStrattner Brian J · Chesapeake, VABuilt 1959 · S/N 24-807

Back to AD 77-13-21