AD 95-22-01
Registered aircraft · 5,258
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:95-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-22-01')
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:95-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-22-01') 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.
N1163MNew World Aviation LLC · Edinburg, TXN116HLWorld Tech Aviation LLC · Valencia, CAN116KCRa Aviation LLC · Dover, DEN116MAFsa Aerospace Inc Trustee · Wilmington, DEN117AACorsair Two LLC · Hillsboro, ORN118BHBighorn Airways Inc · Sheridan, WYN118CDFirst Aviation Service Corp · Wilmington, DEN118JKRegistered aircraftN118MTOne World Aviation 118 LLC · Atlanta, GAN118RJDodson International Parts Inc · Rantoul, KSN118RWCitation N118rk LLC · Houston, TXN1194AGta Air Inc · Addison, TXN119AFAviation Sales Associates LLC · Costa Mesa, CAN119EDCentral Virginia Aviation Inc · North Dinwiddie, VAN119FMOceanside Aviation LLC · Santa Monica, CAN119LCBravo 969 LLC · Mayo, FLN119NAUnited States Government · Washington, DCN11ESale Reported · Wayne, NESale reported, canceledN11GJGlobal Jetcare Inc · Brooksville, FLN11JARegistration Pending · Denison, TXRegistration pendingN1200NCoulson Aviation (USA) Inc · Portland, ORN120HAAstley Mark C · Wayne, NJN120HL4e Holdings LLC · Milwaukee, WIN120JJAviation Sales Associates LLC · Costa Mesa, CAN120SBHrs Aircraft LLC · New York, NYN120UAUnited Airlines Inc · Chicago, ILN120WJFly Vulture Aviation LLC · Southwest Ranches, FLN12109United Airlines Inc · Chicago, ILN12114United Airlines Inc · Chicago, ILN12116United Airlines Inc · Chicago, ILN12125United Airlines Inc · Chicago, ILN121APCrossland Global Sky LLC · Rogers, ARN121CBClark Andrew R · Woodside, CAN121CNScl Family Sr-22 LLC · San Antonio, TXN121CZN121cz LLC · Milwaukee, WIN121HLAircraft Holding Solutions LLC Trustee · Newark, DEN121KMWings By Dkw LLC · Lake Charles, LAN121MJIal Corp · Lewes, DEN12216United Airlines Inc · Chicago, ILN12218United Airlines Inc · Chicago, ILN12221United Airlines Inc · Chicago, ILN12225United Airlines Inc · Chicago, ILN12238United Airlines Inc · Chicago, ILN122HL4e Holdings LLC · Milwaukee, WIN122NBSunfair Commercial Leasing Inc · Yakima, WAN122UAUnited Airlines Inc · Chicago, ILN1232KCorporate Air LLC · West Mifflin, PAN1234QDembowski Rodrick · Seattle, WAN1238RLtx Consulting LLC · Austin, TXN123EGButler Brian S · Oklahoma City, OK
Back to AD 95-22-01