AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N3EM3em LLC · Karnack, TXN3GWN3gw LLC · Champaign, ILN3HJTangobravo LLC · York, NEN3HKInternational Air Services Inc Trustee · Carson City, NVN3KKKraussman Daniel J · San Antonio, TXN3KPAllied Asset Management LLC · Oklahoma City, OKN3LNAllen Jeffrey W · Crestwood, KYN3LWKyllar LLC · Madison, WIN3MUAero Equities LLC · Ventura, CAN3QASg&F LLC · Riverside, CAN3QBKetcham James Schuyler Trustee · Malibu, CAN3QEQe Air Inc · Naples, FLN3UCYahraus Andrew · Phoenix, AZN3VACook Marvin R · Portales, NMN3VBHarrison Ted W · Grapevine, TXN3WFFolk Wolfgang · Fairfield, CAN3YHMarsaudon David · Friday Harbor, WAN3ZGIsbell Tony A · Rainbow City, ALN400APZoie Air LLC · Fort Lauderdale, FLN400ARArh Aviation LLC · Gainesville, FLN400ATAlpha Tango Aviation Inc · Middletown, DEN400AWThomson Roy · New Castle, CON400EJFletcher Development LLC · Scottsdale, AZN400GMN400gm LLC · Salisbury, MDN400JVAero Beach Club LLC · North Palm Beach, FLN400LDLa Davis LLC · Strawn, TXN400LPLuitjens Jacob Jelte · Cascade Locks, ORN400MERegistered aircraftN400MHOmega Aero LLC · Newark, DEN400MPPilipis Maximiliano F · Brooksville, FLN400RDBhr Leasing Corp · Wilmington, DEN400TFTef Air 2 LLC · New York, NYN400TNSea&Air LLC · Beaufort, SCN400TRAerial Ventures 1 Ltd · Austin, TXFirst renewal noticeN400TVA & A Farms Inc · Arbuckle, CAN400TXNo-Bull Enterprises LLC · Saint Francis, KSN400UKInternational Air Services Inc Trustee · Carson City, NVN400VTValiair Limited Co Trustee · Casper, WYN400WTArtspret Aviation LLC · Sugar Grove, ILN401AZTre Aviation Corp · Wilmington, DEN401BRBethel View Holdings LLC · Danbury, CTN401CAGlenn Roger H · Pacifica, CAN401CMRmc Holdings Inc · Denver, CON401MHKenmore Crew Leasing Inc Trustee · Bellingham, WAN401MPFriend Ships · Lake Charles, LAN401MROk Av8r LLC · Iowa Park, TXN401PSLesmeister Dean · Kindred, NDN401RGRomeo Golf Holdings LLC · Carlisle, IAN401SDThree Hands Farms LLC · Aldie, VAN401SXHyannis Air Service Inc · Hyannis, MA
Back to AD 2012-10-13