AD 84-10-01 R1
Registered aircraft · 20,481
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
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N735ZAHine Butler · Los Altos, CAN735ZBCarroll Robert Douglas Jr · Moab, UTN735ZDLansink Ronald L Trustee · Danbury, IAN735ZFKatsinis James N · AthensNon-citizen corporation, flight hours not reportedN735ZHWonder Lake Flying Club Inc · Wonder Lake, ILN735ZKFine Frank E · Oakdale, CAN735ZNBerquist Harold J · Loveland, CON735ZPThornton Allan F · Norfolk, VAN735ZQDc Marketing LLC · Collierville, TNN735ZT3d Aircraft A California Corp · Simi Valley, CAN735ZVWilhelm James S · Tehachapi, CAN735ZWBarge And Associates Inc · Houston, TXN735ZZSkidmark Landings LLC · Bozeman, MTN7360CKacoyanis John George · Bedford, NHN7360EShacklette Donald J · Smiths Grove, KYN7360QNavolutions Inc · Pleasanton, CAN7360SSsk Ventures LLC · Eagle, CON73612American Aviation Inc · Page, AZN7361CFocused Holdings LLC · Wellsville, UTN7361NWilcox Aerial Applications Inc · Tilden, NEN7361XJohnson Michael · Huntington Beach, CAN7362SRegistration Pending · Colleyville, TXRegistration pendingN7362XDraco Flight School Inc · Chino, CAN7362Y32 Drakes LLC · Sulphur Bluff, TXN7363NDef Air LLC · Buchanan Dam, TXN7363QTyleranna Adventures I LLC · Boerne, TXN7363SCoral Air LLC · Rock Rapids, IAN7364EGreat Commission United · Montague, MIN7364RCentral Shop LLC · Shadyside, OHN7364WM Star Aviation LLC · Oconto, WIN7365SNorthgate Aviation Inc · Chico, CAN7365XSelectaire LLC · Rcho Sta Marg, CAN73663Summit Lake Aviation Inc · Olympia, WAN7366EZarko David S · Fenton, MIN7366QScheidt Eric D · Columbus, INN7366TJones Bruce E · Aurora, COFirst renewal noticeN7367CRuebling Edward X · Anchorage, AKN7367SCentral Plains Aero LLC · Wichita, KSN7368NAka Fun LLC · Jupiter, FLN7369SBlue Skies Aviation LLC · Gig Harbor, WAN736BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN736LFAvitran Inc · Coral Gables, FLN736MJClover Park Technical College · Lakewood, WAN736NJCarr Gary A · Rittman, OHN736RAWernsman William Adam Trustee · Garnett, KSN736TGMagleby Herbert K · Surprise, AZN736VKGeneral Aviation LLC · Henderson, NVN736WPN736wp LLC · Waterford, NYN736WXStone Aviation LLC · Cusick, WAN736XGStonecipher Guy Austin III · Beaumont, TX
Back to AD 84-10-01 R1