AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N6462CA&J Aircraft Leasing Inc · Burlington, CON6462DN2893e LLC · Reno, NVN6462JRentz Bradford C · Baxley, GAN6462QPlummer Joshua · Fort Mill, SCN6462RGoodens Floorcovering Inc · Tallapoosa, GAN6462UAnderton Roy · Colbert, OKN6462VVanbergen Shaun S · Ashland City, TNN6462WBauer Richard M · Greensboro, NCN6462ZMinden Soaring Club Inc · Minden, NVN6463GTeens-In-Flight Inc · Palm Coast, FLN6463JSorenson Mark A · Senoia, GAN6463QLyon Aviation Inc · Pittsfield, MAN6463VFrolander Christopher G · Chugiak, AKN6464DHoney B LLC · Hillsboro, ORN6464MMajorek Miroslaw · Mountain View, CAN6464RChristiansen Aviation LLC · Wilmington, DEN6464USherman Stanley Robert · Altus, OKN6464WTechnical Educational Services Inc T/A · Virginia Beach, VAN6464ZFlying Tiger LLC · Birmingham, ALN64655Dave'S Aircraft Inc · Edgewater, FLN64657Elite Approach LLC · Chesterfield, MON6465JAardvark Aviation Inc · Greentown, INN6465PKesser Gilbert M · Culpeper, VAN6465QLeckrone Steven R Trustee · Mustang, OKN6465THurricane Corp · New York, NYN64664Szpak Michael W · Albany, GAN6466CConey Island Lunch LLC · Erie, PAN6466DValley River Leasing Inc · Murphy, NCN6466JHomesick Angel Aircraft Management · Grove, OKN6466QSherrod Paul A Jr · Opelika, ALN64674Vaughan Stephen D · Finchville, KYN64678Ocean Aviation Inc · Berlin, MDN64679Miami Valley Career Technology Center · Clayton, OHN6467ALouise Walters Enterprises · Malabar, FLN6467CSugden William H · Alexandria, MNN6467JAircraft Guaranty Corp Trustee · Oklahoma City, OKN6467LHoc Services Inc · Homer, AKN6467RKightlinger Kenny L Jr · Murfreesboro, TNN6467WStichnoth Marvin L · Bourbonnais, ILN64686Kadena Aero Club · Apo, APN6468DShorter Laurence K · Hinsdale, MAN6468FFlying Aces Aero Fleet Inc · Guyton, GAN6468JTxfliers Aviation LLC · Corpus Christi, TXN6468PTevis Aviation Enterprises LLC · Newcastle, OKN6468RMargolis Brian M · Florence, MAN6468ULi Yoi Y · Largo, FLN6469BHale Debra A · Chugiak, AKN6469JDouble Eagle Flyers LLC · Albuquerque, NMN6469MGeneral Aviation Support Corp · Rosamond, CAN6469PSunrise Aviation Inc · Ormond Beach, FL
Back to AD 81-18-04 R2