AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N16223Flyhnz LLC · Oxford, NCN16225Tumminaro Michael · Neodesha, KSN1622FN1622f LLC · Grand Prairie, TXN1622QSchweim Robert J · Ocean City, NJN16238Hayes Lance Garett · Opelousas, LAN1623FVilvens Justin T · Granville, OHN1623QHigh Exposure Inc · Wilmington, DEN16243Como Jerry Wayne · Murfreesboro, TNN1624FPruitt Leonard E · The Colony, TXN1624VSmith John C · Greenville, NCN1624YFallbrook Fly Girl LLC · Lakeside, ORN1625DHatcher Aviation LLC · Little Rock, ARN1625NSowell Thomas A · Port Orange, FLN1625QRegistration Pending · Powell, TNRegistration pendingN1625YBoyd Jeffrey J · Justin, TXN1626FDelgadillo Jose M · League City, TXN1626NHoward Kenneth L · Collinsville, OKN1626YJohnson Dean William · Springvale, MEN1627FJrm Equipment LLC · San Francisco, CAN1627QSky Time LLC · Fort Lauderdale, FLN1627VSmith Eric M · Sanger, TXFirst renewal noticeN1627YJohnson Douglas J · O Fallon, ILN1628QMckeeman Kevin Tee · Abilene, KSN1629DEbenezer Richard C · Soldotna, AKN1629FHurricane Enterprise LLC · Buffalo, WYN162BBAsbery David S · Mt Vernon, ILN162BSRees John William · Prescott Valley, AZN162CCOn Time Aviation Corp · Parsippany, NJN162HGWillis Danny · Baldwyn, MSN162HKBalance Industries Inc · Buellton, CAN162HRHk Aviation LLC · Conrad, MTN162LFFeick Larry E · Crestline, OHN162LMBeagle Scents LLC · Chandler, AZN162LSN162ls LLC · Burlington, WYN162PGPylkas Trisha A · Gold Canyon, AZN162YSkys The Limit Investments LLC · Sanders, KYN162YENickerson Gavin N · Milton, GAN1630NNewton Zachary · Bowling Green, KYN1630VBaeseman Alex J · Moab, UTN1630YHart Gregory D · Medford, ORN1632FBastion Allen L · Conton, PAN1632NVelemirov Michael L · Akron, OHN1634DBlackhawk Aviation LLC · Medicine Park, OKN1634FWings & A Prayer Gso LLC · Weaverville, NCN1634NGooden John A · Tulsa, OKN1634YWager Douglas K · Mobridge, SDN1636DDeruiter Don DBA · Lake City, MIN1636FRolfe Harold B Trustee · Holtville, CAN1636VMoeser David P · Colton, ORN1636YHokanson Anthony Drake · La Crosse, WI
Back to AD 94-05-05 R1