AD 2000-22-18
Registered aircraft · 914
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:2000-22-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-18')
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:2000-22-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-18') 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.
N4619MNfv LLC · Helena, MTN461BCB&K Leasing Inc · Nantucket, MAN4621MBassline Logistics LLC · Watauga, TNN463KBBuster Air LLC · Miami, FLN4657ATessos Air Service Inc · Wilmington, DEN468PN Fl Servicing LLC · Santa Rosa Beach, FLN46DMEdwards John Guerrant · Stoneville, NCN46HW2j2g LLC · Wilmington, DEN4733MNelson Steven L · Hampton, MNN476EWWny Air Inc · Dover, DEN47GAJcb Air LLC · Southport, NCN48CCC Baron LLC · Lafayette, LAFirst renewal noticeN48JClever Conceptz LLC · Danbury, CTN48TXCulater LLC · Indianapolis, INN498CPConstruction Design Management LLC · Bowling Green, KYN49DCenturian 94n LLC · Ripon, CAN4HESouth Florida Aerobatics LLC · West Palm Beach, FLN4JADiamond Aviation LLC · Tuscaloosa, ALN4LWWilliams Jason Allen · Cypress, TXN4WZMulligan Peter · Richardson, TXN500BAKw Plastics · Troy, ALN500LDJ & H Investment Corp Inc · Columbia, MON500TLSententia LLC · Highland Park, ILN501MLVotava Paul A · Mcintosh, MNN503BAP&B Aviation Corp · Wilmington, DEN504TBAutomotive Air III LLC · Belcamp, MDN5065RZ J Express LLC · Lewes, DEN5096RProvestment International LLC · West Melbourne, FLN509PTailwindsbikelyft LLC · Hannibal, MON50SSAviation Trust Company LLC Trustee · Oklahoma City, OKN511CFFendler Michael J · Pittsfield, MEN511DFKma Aviation LLC · Phoenix, AZN515RGDowney Paul J · Newington, NHN517MRDgw Aviation LLC · Elverson, PAN51FDH2f2 LLC · Prairie Village, KSN51MTTrantham Joey L · Panama City, FLN520LLMesoamerica Aviation Corp · Wilmington, DEN521WSCmt Properties LLC · Laurel, MSN524CBTechnical Film Systems Inc · Camarillo, CAN524RTN524rt LLC · Greensboro, NCN525TMVertivue LLC · Allentown, PAN526BDLoeffelholz John W · Fort Worth, TXN527BHRed River Cellular Telephone Corp · Paris, TXN527TAPlane Leasing LLC · Wilmington, DEN531KCConstantine LLC · Fort Collins, CON537SWBingham Leasing Co Lc · Mesa, AZN53RTCas Capital Holdings LLC · Newark, DEN541JESimpson Kendal · Port Orange, FLN543RBBaron Aviation LLC · Calera, ALN549PTGrant P T · Musella, GA
Back to AD 2000-22-18