AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5483LLawton George F · Auburn, CAN54844Dynasty Adventure Inc · Mentone, CAN54849Colorado Northwestern Community College · Rangely, CON5484BUnwrapped LLC · Dover, DEN5484DAerobiz LLC · Lewes, DEN5484JCaba Joseph · Covington, LAN5484LAugustine Robert J · The Villages, FLN5484NYeoul 182 LLC · Sanford, FLN5484PRussi Kenton S · Caldwell, IDN54851Metz William H · Laurel, MTN54855Christiansen Aviation LLC · Wilmington, DEN5485BSutton Aircraft Salvage LLC · Palmer, AKN5485EColorado Parks And Wildlife · Grand Junction, CON5485HGiron Lawrence · Anchorage, AKN5485KBarr Air Patrol LLC · Mesquite, TXN5485LBeaudry Charles F · Graham, NCN5485MN446rh LLC · Helena, MTN5485PGoodlin Scott · Tulare, CAFirst renewal noticeN5486BVerhaaren Inc · Naples, FLN5486DFord Bernard DBA · Sidney, NYN5486LStelly Christopher · Houston, TXN5486NTorgerson Roald L · Lewistown, MTN5486PHorton James D · Las Vegas, NVN5486SPlane Fun Inc Tr Trustee · Snellville, GAN5487Rhj Investments LLC · Show Low, AZN5487DSims Daniel E · Salem, ORN5487FKettlehut Alan W · Ceresco, NEN5487KRingen Marvin O · Beaverton, ORN5487LLaw C Scott · Oklahoma City, OKN5487PDotterer Kurt Samuel · Bloomfield, IAN5487USuss Charles H Trustee · Woodford, VTN54881Huntsville Soaring Club · Brownsboro, ALN5488JGrace Aviation LLC · Rogers, ARN5488PScheuermann Hugo T · Cape Coral, FLN5488SJanssen Paul · New Castle, INN5488TWestphal Ronald R · Aurora, ILN54898Central Indiana Soaring Society · Yorktown, INN5489BNewhouse David · Belvidere, NJN5489DJrh Wings LLC · Alva, OKN5489LRib Runner LLC · Sioux Falls, SDN5489PClarke Adam M · Lompoc, CAN548ASouthern Illinois University · Murphysboro, ILN548CLSpielmann Thomas G · Aurora, INN548CWCentral Washington University · Ellensburg, WAN548DGorowsky Craig · Tucson, AZN548EBRomeo Charlie Aircraft Partners LLC · North Little Rock, ARN548ECRaney James R · Tucson, AZN548EPGulf Coast Aviation LLC · New Orleans, LAN548EREmbry Riddle Aeronautical University Inc · Prescott, AZN548GAHyannis Air Service Inc · Hyannis, MA
Back to AD 2007-04-19 R1