AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-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:2006-10-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:2006-10-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:2006-10-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.
N136VUPerformance Aircraft Sales Inc · Lincoln, NEN136YJanoski David M · Fort Worth, TXN13710Registered aircraftN1371JSajko Gary · Chesapeake, VAN13733Kelleher James · Nevada City, CAN13734Red Bird Flyers LLC · Acton, MAN1373WGarces Manuel E · Jefferson, GAN1373ZHoitt Edward D Jr · Deerfield, NHN13740Gigax Steven G · Archbold, OHN13747Namund LLC · Roscommon, MIN13749Son Of Jubal Ministry LLC · Bainbridge, GAN1374JE2a Distributors Inc · Monroe, GAN1374WWade Deborah D · Mineral Wells, TXN13756Sky West Aviation Inc Trustee · Albuquerque, NMN13757Nelson Robert Brett · Point Roberts, WAN1375CConn James Michael · Alexandria, MNN1375JRegistration Pending · South Burlington, VTRegistration pending, pending cancellationN1375WAndrews Kevin M · Hermitage, TNN13760Chiniewicz Michael · The Colony, TXN1376JHogue Robert D · Rockwall, TXN1376WMarling Russell Cole · Highlands, NCN1377JDurrah Anthony E · Charlotte, NCN1377SUniversity Of Michigan Flyers Inc · Ann Arbor, MIN1378JAeronautics Inc · Vero Beach, FLN1379TGordon William E · Summit, NJN137ACHare Michael Aubrey · Foley, ALN137ASFlight Leasing Corp · Wilmington, DEN137BCJrnd Corp · Lewes, DEN137CCMore Right Rudder LLC · Sioux City, IAN137CPCivil Air Patrol · Maxwell Afb, ALN137DBMichel Daniel T · Sterling, AKN137DCThompson Joseph D · Alliance, NEN137DSOrr Sam L Jr · Buford, GAN137GLynes Geoffrey · Halifax, MAN137JHFlatspin LLC · Belle Chasse, LAN137JSCompound Holdings LLC · Auburn, NYN137JWNetwork Sales & Leasing Inc · Newtown, PAN137LHAero Holdings LLC · Palm City, FLN137MEChristiansen Aviation LLC · Wilmington, DEN137MWMcphillips Flying Service Inc DBA · Beaver Island, MIN137NAerospace Trust Management LLC Trustee · Wilmington, DEN137NDUnd Aerospace Foundation · Grand Forks, NDN137PCFlight Fundamentals Inc · Willcox, AZN137RCowboy Up Aviation LLC · Frenchglen, ORN137RJUaa International Inc · La Verne, CAN137SMarshall James W · Neptune Beach, FLN137SDHann Joseph C · Flemington, NJN137TDWw Flying Services LLC · Waller, TXN137TSArk Aviation LLC · Moncks Corner, SCN137TTBk Aviation Inc · Mansfield, TX
Back to AD 2006-10-21